Can I query data by record count?

[EddyLLC]

Is there a way to query one record from a table. Specifically say the second record or the third record. I mean the criteria would not be specific data it would simply be the order of the records. I want to see the fourth record for example.

Thanks.

 

[PHV]

In a relational database there is no notion of record number.
To have a sorted dataset you have to use an ORDER BY clause.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886