Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
get second to last record in file
- Thread starter Robert79
- Start date
To retieve the second to last row in a table myTable with primary key myPK, you can try something like this:
Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
Code:
SELECT * FROM myTable
WHERE myPK=(
SELECT MAX(myPK) FROM myTable
WHERE myPK<(SELECT MAX(myPK) FROM myTable)
)Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
- Thread starter
- #3
- Status
