how can we find max values from any table of any thing using self join?reply by query format.

On 2014-06-12 00:44:36.0
amrendra

The query should be like this

select * from student s1 where 0=(select count(sid) from student s2 where s1.sal<s2.sal);

am i correct ?

On 2014-06-12 02:22:53.0
hablu