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)

Tuesday, 17 January 2017

Hi  this is my first day on   blogger its smiley superb 

find max sal

select * from emp a where 1 (select count(distinct(b.sal)) from emp b where b.sal>=a.sal)