Question

Using SQL:

Create a simple query that groups information by a specific column. Explain each step.

Answer 1

The SQL query that groups information by a specific column is GROUP BY.

Consider the following table EMPLOYEE.

The SQL query to select name and sum of salary grouped by the column name is

SELECT NAME,SUM(SALARY) FROM EMPLOYEE GROUP BY NAME;

The result is

Thus query returned the names and sum of salaries of employees having same name.

Here the name Ashish is having two rows and the sum of his salary is 3000

GROUP BY Syntax SELECT column_name (s) FROM table_name WHERE condition GROUP BY column_name(s) ORDER BY column_name (s);