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