Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-12 : 19:59:58
|
Gabe writes "I'm running an Access 2000 database via ODBC on NT4. Inside my database is table "data." Table "data" has fields "id", "date", "time", "t1", and "t2". "id" is an autonumber that is indexed with no duplicates allowed, and the rest are text fields. How can I send a query that only will only return the last x number of rows(my specific application calls for the last 10 records) in the table?
Thanks for your time,
Gabe" |
|
|
|
|
|
Select only the last few records