Select * from SomeTable

where SNO>=

(

Select MIN(RR.R) from

(

Select TOP 10 T.SNOS as R

FROM

(SELECT CNO, Min( SNO ) AS SNOS FROM SomeTable GROUP BY CNO ) T

ORDER BY T.SNOS ASC

) RR)...

Hey Ramesh,

Thanks a lot man. This exactly what i wanted.

what i am saying is my return value should be

63

46

56

... and so on

Thanks for ur help

thanks for the help but the problem here is that the order is changing and thats something which i don;t want. Its like when do the query the values returned...