hello friends,
this was a query sent by a friend,can any one explain it in detail and how this work. i am new to sql and not so good at corelated subquery.

select distinct value from table a where 8=(select count(distinct value) from table b where b.value >= a.value);

thank u all ......
arun

Hi,

Please go through the attached document.

Attached Files

logic of nth highest.zip (5.6 KB, 13 views)

__________________
Thanks
Sandesh S
http://sanssql.blogspot.com/