Having

•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