Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 10th, 2009
SELECT column_name, aggregate_function(column_name)FROM table_name
WHERE column_name OPERATORVALUEGROUPBY column_name
SELECT last_name,COUNT(*)FROM user_list
WHERESUBSTR(last_name,1,1)BETWEEN'A'AND'W'GROUPBY last_name;-- you can also use the GROUP BY statement on more than -- one column, like this:SELECT Customer, OrderDate,SUM(OrderPrice)FROM Orders
GROUPBY Customer, OrderDate
-- the result will be grouped by Customer and then OrderDate