•Using HAVING clause to specify which groups are to be displayed, thus further restricting the group on basic of aggregate information
Select job_id, sum (salary) Payroll
From employees
Where job_id not like '%REP%'
Group by job_id
Having sum (salary) > 13000
Order by sum (salary);
0 comments:
Post a Comment