Explain following term: Group by clause

12views

written 9.0 years ago by

meghalikalyankar • 2.3k

-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