How to fetch particular record?

[skumar]

Hi all,

I have 1 million rows in my target and i am using these records in a lookup table .now the problem for me is i am joining this look up table with some other table and i want one particular row from that lookup how to get the 1000th record directly from that lookup table instead of processing all the records

THANKS IN ADVANCE.

KUMAR.

[thumsup9]

I am not sure if this what you want, but you can wrtie that particular 1000th record to your lookup file and the use it in your lookup with other table. This way you dont have to looup all the records.

HTH

[DSguru2B]

What is your database? I know in SQLServer you can use something like

Code: Select all

Select TOP 1 FROM (select TOP 1000 from TABLE
ORDER BY KEY DESC)