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
Labels:

No comments:

Post a Comment

Subscribe to: Post 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