MAX function with having clause

Submitted by:Jhon Smith

Date added:13 March, 2012

Category:PL SQL

PL/SQL code example for using the MAX function with having clause

Tags: max function

Code Snippet:

SELECT JOB, MAX(sal) as "Highest salary"
FROM emp
GROUP BY job
HAVING MAX(sal) < 50000;
 
 

Comments