Oracle PL/SQL: SELECT with GROUP BY Clause - The GROUP BY clause is used in conjunction with the aggregate functions to group the result-set by o

Quick Search:

Oracle PL/SQL: SELECT with GROUP BY Clause

Jump to:

Category: >> Oracle PL/SQL >> SELECT with GROUP BY Clause

<< last

next >>

Snippet Name: SELECT with GROUP BY Clause

Description: The GROUP BY clause is used in conjunction with the aggregate functions to group the result-set by one or more columns.

Another way of saying this is that
GROUP BY allows the results to be sorted by the GROUP BY condition or column.

Also see:
» TABLE: Using Select Statement With Data
» SELECT: Case insensitive search
» SELECT: Partition Select
» SELECT: Select For Update
» SELECT: Using Functions
» SELECT: Get DISTINCT or UNIQUE values
» SELECT: Get UNIQUE and DISTINCT values
» SELECT: Scalar Select
» SELECT with HAVING Clause
» SELECT with WHERE Clause
» SELECT with SAMPLE clause
» SELECT placement
» SELECT into a table
» SELECT name columns
» SELECT
» UPDATE: Update from a SELECT statement
» Inserting into SELECT statement
» INSERT with Select

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 10th, 2009

SELECT column_name, aggregate_function(column_name)
FROM table_name
WHERE column_name OPERATOR VALUE
GROUP BY column_name
 
 
SELECT last_name, COUNT(*)
FROM user_list
WHERE SUBSTR(last_name,1,1) BETWEEN 'A' AND 'W'
GROUP BY last_name;
 
-- you can also use the GROUP BY statement on more than 
-- one column, like this:
 
SELECT Customer, OrderDate, SUM(OrderPrice) FROM Orders
GROUP BY Customer, OrderDate
 
-- the result will be grouped by Customer and then OrderDate