What is SQL GROUP BY clause?

S

Shumit Pathak

SQL GROUP BY SYNTAX

SELECT column_name1, column_name2, column_name3, ...

FROM table_name

WHERE [condition]

GROUP BY column_name1, column_name2,column_name3,  ...

ORDER BY column_name1, column_name2, column_name3, ...;


SQL GROUP BY CLAUSE

GROUP BY clause is used to group rows with the SELECT statement to arrange identical data into groups.

The SQL GROUP BY clause is often used with aggregate functions like COUNT, MAX, MIN, SUM, AVG to group the result-set by one or more columns.

0 votes

Your Answer

Email Us: advertise@gdatamart.com

Donate Us: Support to GDATAMART

LifeStyle & Fun

© 2024 GDATAMART.COM (All Rights Reserved)