Hi

I need to display the latest (Top10) entries on my asp page. The data is sorted by ID(PK) thus the latest 10 entries will be from the bottom. Entries contain a dateentered field which is datetime datatype.

How can i return this data by using a single query? The only way I could thought off is do a Select Count, Get the number of records, Subtract 10, Do the query and loop as many times as the result (Count-10) and then only start writing the data... Just like to know if there is an easier way? (Im using sql server)

Thanks in advance
Marnus

Hi Marnus,

You don't have to go round the circle to reach there. Instead you can use this.

Select top 10 * from TABLENAME order by COLUMNNAME desc

This gets you the latest 10 records based on the COLUMNNAME that you use in the ORDER BY clause.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

The only downside of this method is that your dataset is now ordered in reversed order. Use this query to get the same 10 records, but in ascending order:

SELECT Col1, Col2 FROM MyTable WHERE Col1 IN (SELECT TOP 10 Col1 FROM MyTable ORDER BY Col1 DESC) ORDER BY Col1 ASC

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Distant Voices by Bush (Track 13 from the album: Razorblade Suitcase) What's This?

Thanks, Thats working.

Regards
Marnus