MySQL

Selecting the 3 latest entries in a table

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Oct 2007

Posts: 260

Reputation: Venom Rush is an unknown quantity at this point

Solved Threads: 2

Venom Rush Venom Rush is offline

Offline

Posting Whiz in Training

Selecting the 3 latest entries in a table

Jan 15th, 2008

Hi guys and gals

Just curious to know if it's possible to select the 3 latest entries in a table. Would be an added bonus to my project.

•

Join Date: Feb 2005

Posts: 1,181

Reputation: hollystyles will become famous soon enough

Solved Threads: 67

hollystyles hollystyles is offline

Offline

Veteran Poster

Re: Selecting the 3 latest entries in a table

Jan 15th, 2008

Use the LIMIT keyword (Similar to TOP in MSSQL) If you use ORDER BY to order the results descending, so that the latest records will be at the top of the result set. Then use LIMIT to get just the first three of those records.

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
SELECT someColumn 
FROM someTable 
ORDER BY someColumn DESC 
LIMIT 3
SELECT someColumn 
FROM someTable 
ORDER BY someColumn DESC 
LIMIT 3