bruce wrote:
i have a tbl with the following...
foo date1 foo2 date2 etc...
how can i do a select to get the last or 1st row based on the (latest/earliest) date?
SELECT * FROM tbl order by datecolumn DESC LIMIT 1; SELECT * FROM tbl order by datecolumn ASC LIMIT 1;
can't seem to get it to work..
thanks
-bruce
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]