< Sql Tutorial

Sql Group By Clause

← Previous Next →


Group by clause is used to group the results of a SELECT query based on one or more columns. It is also used with SQL functions to group the result from one or more tables.

Syntax:

SELECT column_name, function(column_name)
FROM table_name 
WHERE condition 
GROUP BY column_name

Example of Group by in a Statement

Consider the following Emp table.

eid name age salary
401 Anu 22 9000
402 Shane 29 8000
403 Rohan 34 6000
404 Scott 44 9000
405 Tiger 35 8000

Here we want to find name and age of employees grouped by their salaries SQL query for the above requirement will be,

SELECT name, age 
from Emp group by salary

Result will be,

name age
Rohan 34
shane 29
anu 22

Example of Group by in a Statement with WHERE clause

Consider the following Emp table

eid name age salary
401 Anu 22 9000
402 Shane 29 8000
403 Rohan 34 6000
404 Scott 44 9000
405 Tiger 35 8000

SQL query will be,

select name, salary 
from Emp 
where age > 25
group by salary

Result will be.

name salary
Rohan 6000
Shane 8000
Scott 9000

You must remember that Group By clause will always come at the end, just like the Order by clause.

← Previous Next →