SQL Reference - SELECT Statement Syntax

GROUP BY Clause

Column Names from the Select List

Column Names Not in the Select List

HAVING Clause - Can contain any of the following:

• Column Value Criteria
• Column Value Aggregations
• Nested Selects

Column Names From the Select List

select customer_no, sum(amount) from orders group by customer_no

select city, state, count(distinct company) from customers group by city, state

Column Names Not in the Select List

select status, sum(amount) from orders group by customer_no, status

select count(company) from customers group by state

Having

select customer_no, sum(amount) from orders
group by customer_no having customer_no = 1001

select customer_no, sum(amount) from orders
group by customer_no having status != 'shipped'

select status, sum(amount) from orders group by status having customer_no
in (select customer_no from customers where company='systems')

top