S-SQL Examples H

S-SQL Examples Home Page

A B C D E F G H I J K L M N O P R S T U V W Special Characters Calling Postgresql Stored Functions and Procedures

Having

Postgresql documentation here 

  (query (:select (:count 'c.id) 'r.name
                :from (:as 'countries 'c)
                :inner-join (:as 'regions 'r)
                :on (:= 'c.region-id 'r.id)
                :group-by 'r.name
                :having (:< (:count 'c.id) 10)))

((5 "Central Asia") (5 "North America") (6 "Central America"))