Oracle Group By | Group By - oracle tutorial - sql tutorial
What is Oracle GROUP BY clause ?
- The Oracle GROUP BY clause is used in a SELECT statement to collect data across multiple records and group the results by one or more columns
oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , plsql
Syntax:
SELECT expression1, expression2, ... expression_n,
aggregate_function (expression)
FROM tables
[WHERE conditions]
GROUP BY expression1, expression2, ... expression_n;
click below button to copy the code. By - oracle tutorial - team
Oracle Group By - Having Clause
Example:
SELECT orderid, COUNT(*) AS "Number of orders"
FROM orders
GROUP BY orderid
click below button to copy the code. By - oracle tutorial - team
Using Count function
Sample Database
- We have a table called orders with three fields (id, customer_name, and orderid).
Group by using Count Function
- Using aggregate function (Count) we are ordering the Order ID from orders table and grouping them by Number of Orders.
- The number of orders has sorted according to the order ID.