select * from emp a where 1 (select count(distinct(b.sal)) from emp b where b.sal>=a.sal)
Subscribe to:
Comments (Atom)
find max sal
select * from emp a where 1 (select count(distinct(b.sal)) from emp b where b.sal>=a.sal)
select * from emp a where 1 (select count(distinct(b.sal)) from emp b where b.sal>=a.sal)