Select Last 10 records

[Leon1977]

I have an ID autonumber column in a TABLE, with lets say 100 rows from 1 to 200 (some of the rows ar mising)
so I want to display the last 10 records acording to the ID column
something like :
select * from TABLE
where ID > (select max(ID)-10 from TABLE)
but this doesn't do becouse it could return less then 10 records (if some of the rows between 200 and 190 are missing)

 

[mwolf00]

SELECT top 10 * FROM myTable ORDER BY id DESC -----------------------------------------------------------------
"The difference between 'involvement' and 'commitment' is like an eggs-and-ham breakfast: the chicken was 'involved' - the pig was 'committed'."
- unknown

mikewolf@tst-us.com

 

[Leon1977]

\perfect ... thanx a lot