Group By In SQL

Chapter: SQL Commands Last Updated: 12-11-2020 19:40:59 UTC

Program:

            /* ............... START ............... */
                
SELECT col1,col2
FROM table
WHERE conditions 
GROUP BY col1,col2

SELECT col1,count(*)
FROM table
WHERE conditions 
GROUP BY column1
                /* ............... END ............... */
        

Output


            
        

Notes:

  • Group By is used to group the row having the same value like "Group by age of person"
  • The GROUP BY statement is often used with aggregate functions.
  • Mostly used aggregate function in group by is COUNT, MAX, MIN, SUM, AVG
Similar Programs Chapter Last Updated
Substring In SQL SQL Commands 27-11-2019
SQL SELECT Statement SQL Commands 16-03-2018

1