how to find the sal > 2500 without using where clause

[PSoni]

hi,

I think this will also do (without max() function)

SELECT ename, sal salary FROM emp
GROUP BY ename,sal
HAVING sal > 2500;


P. Soni