Monday, 16 December 2019

find max sal

select * from emp a where 1 (select count(distinct(b.sal)) from emp b where b.sal>=a.sal)
at No comments:
Labels:
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)

  • (no title)
    Hi  this is my first day on   blogger its smiley superb