Well Dave, It's actually quite simple. All you would have to do is this:
select top 20 * from [the table name] order by [the ID column] desc
The reason you want to order by DESC b/c it list the column from the highest
numbers to the lowest. So, you'll get the top 20 highest records.
Wei
"SkunkDave" <da***********@totalise.co.uk> wrote in message
news:bf**********@hercules.btinternet.com...
I have a table that has numerical ID.
I want a query that will get the 20 highest IDs. So in other words the
query would return the last 20 results entered.
What would even be better is if they were distinct entries by another
column, but it still returned 20 results.
Can you specify in SQL how many results you want?
Thanks
Dave