SQL | GROUP BY and ORDER BY statement in SQL | Sort data | Group rows into summary rows
In this video we will see how to use GROUP BY and ORDER BY statement in SQL.
The GROUP BY statement groups rows that have the same values into summary rows. GROUP BY statement is often used with aggregate functions (COUNT(), MAX(), MIN(), SUM(), AVG()) to group the result-set by one or more columns.
The ORDER BY statement is used to sort the result-set in ascending or descending order.
"Thanks for watching. If you liked this video, make sure to subscribe for more!”
#dataprojecthub
#data_project_hub