Tag: GROUP BY Statement in SQL

Use of GROUP BY Statement in SQL

Use of GROUP BY Statement in SQL: (1) “GROUP BY” is used to group rows having the same value in a column (grouping of records on the basis of column). (2) “GROUP BY” is mainly used with the combination of COUNT(), MAX(), MIN(). (3) Syntax of “GROUP BY” statement is: SELECT Col1, Col2, …ColNFROM table_name1GROUP BY Col2; …