SQL GROUP BY

Send request to get interview tips in PDF format Personal Interview - Answers to frequently asked questions Tips to earn promotions and perks You can also get your answers published How to write a good CV? How to write a good Cover Letter? Tips to become boss's favorite CareerRide is hiring

SQL GROUP BY - Introduction and syntax

---

<<Previous  Next>>

Explain the SQL GROUP BY statement. Write SQL syntax for the SQL GROUP BY statement along with an example.

GROUP BY: It is used with aggregate functions to group the result-set by one or more columns.

Syntax:
SELECT column_name, aggregate_function(column_name) FROM table_name WHERE column_name operator value GROUP BY column_name

Example:
SELECT Emp_id,joiningdt,SUM(salary) FROM employee GROUP BY emp_id,joiningdt

<<Previous  Next>>