bopritchard
Programmer
i want to select the 5 records that have the most current dates in a timestamp field
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Top 5 Records
- Thread starter bopritchard
- Start date
- Status
sleipnir214
Programmer
Something like:
select * from foo order by columnname desc limit 5
should do it. Want the best answers? Ask the best questions: TANSTAAFL!
select * from foo order by columnname desc limit 5
should do it. Want the best answers? Ask the best questions: TANSTAAFL!
- Status
Similar threads
- Locked
- Question