|
SQL Reference |
SELECT Statement |
GROUP BY / HAVING
|
GROUP BY ClauseColumn Names from the Select List Column Names Not in the Select List
Column Names From the Select Listselect 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 Listselect status, sum(amount) from orders group by customer_no, status select count(company) from customers group by state
Havingselect customer_no, sum(amount) from orders select customer_no, sum(amount) from orders select status, sum(amount) from orders group by status having
customer_no |
|
APIs | SQL Reference | Stored Procedures | Third Party Tools | Debugging |
OmniAccess API |
ODBC |
JDBC |
Nested Queries |
SET Operations |
WITH Options |
CURSOR / INSTANCE |
Commands |
Functions |
SQL Server |
Oracle |
MS Access |
Ms Excel |