View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 05:12 PM
SkunkDave
 
Posts: n/a
Default ms access query help

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

Reply With Quote