View Full Version : retrieve last record

03-14-2006, 02:44 AM
i want to retrieve last record from database and display it.
how can i do it

03-14-2006, 01:26 PM
SELECT TOP 1 * FROM table ORDER BY field_id DESC

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum