DML-select-Group by:

nThe GROUP BY keyword is used when we are selecting multiple columns from a table (or tables)

nSyntax:

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

Query:

SELECT Empname, SUM(salary) FROM Emptbl
GROUP BY Empname