Explain following term: Group by clause

3views

written 7.3 years ago by

anjalisharma • 160

•Aggregate functions can be used for some group by clause in this case it will give summary information for that specific group.

Example: Display the maximum salary of all departments in company

SELECT department_id as Dept,

AVG(salary)as Avg

FROM employees

GROUP BY department_id

Create a free account to keep reading this post.

and 5 others joined a min ago.

ADD COMMENT EDIT