SQL Help

Wee · 6 Feb 2007 at 17:12

Working on some web stuff at the moment, and have come across a problem. I have a table in my database that is choco-block full of rows, but only want to display the 5 latest entries instead of them all. I was wondering it there is an SQL statement that is able to only output a specific number of rows?

Wee · 6 Feb 2007 at 18:36

The database is SQL Server 2005.

They won't be indexed by an incremented key number, most likely will be done by date.

Wee · 6 Feb 2007 at 19:52

JonB said:
Something like:

SELECT * FROM <TABLENAME> ORDER BY <COLUMN NAME> DESC LIMIT 5

Will give it a try, cheers.

Wee · 7 Feb 2007 at 08:23

arty said:
I'd have thought it'd be a SELECT TOP 5 * FROM <TABLENAME> ORDER BY <COLUMN NAME> DESC if it's MS SQL Server

arty

Appreciate the help folks, it worked a treat!