SELECT * from TABLE ORDER BY timestampField DESC LIMIT 20;
-----Original Message-----
From: mab@stripped <mab@stripped>
To: MYSQL Mailing List <mysql@stripped>
Date: Thursday, May 20, 1999 1:38 PM
Subject: retrieving the last 20 rows
>Hello,
>
>I have a table with a timestamp(10) column and an auto-increment
>column.
>
>I want to know the most efficient way to retrieve the last
>20 records (by date) in the table which have either been inserted/updated.
>
>Thanks in advance,
>
>Mark
>
>
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail mysql-thread3647@stripped>
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail mysql-unsubscribe@stripped instead.
>
>

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.