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