Hi Thomas,
I agree with you, but in above solution inner sub query will fatch all 60,000 records (WITH ORDER BY) and then will filter out only 500 records.
Is there any way in which oracle work just for 500 records (in a particular order), and should not work (fatch) additional 59,500 records?
Thanx in advance.
Sukhveer Singh