Originally Posted by ashin

Hi..is it possible to write the same query without using top & max...
can anyone tell me??

Yes it is possible to answer by using correlated queries.

[sql]select sal from emp e where 1=(select count(*) from emp where e.sal<sal);[/sql]


This is a cheap query written..............asdfadfaaf