Im using SQL 7.0. I have 1 table with 6,000 records. How can I go to record 101 (i mean row 101 of my table) using a sql statement. Does anybody?
thanks in advance
Printable View
Im using SQL 7.0. I have 1 table with 6,000 records. How can I go to record 101 (i mean row 101 of my table) using a sql statement. Does anybody?
thanks in advance
SELECT TOP 1 * FROM Table WHERE FieldA NOT IN (SELECT TOP 100 FieldA FROM Table)
if there is a specific identifier for that record (such as a unique record number or something) then you can do
SELECT * FROM tablename WHERE recordnumber = " & txtRecordNumber.Text & "
this really depends on how you specify getting the recordnumber, whether it will be hard coded or there will be something like a textbox that a user can enter a recordnumber into.