MySQL Forums
Forum List  »  Other Migration

Re: MAX in sql, is there a problem accept Max in mysql
Posted by: Nick Roper
Date: August 12, 2004 02:14PM

If you want to select all columns from the row that has the maximum ID value, then:

SELECT * FROM tblhonores
ORDER BY ID DESC
LIMIT 1;



--
Nick Roper

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MAX in sql, is there a problem accept Max in mysql
2151
August 12, 2004 02:14PM


Sorry, you can't reply to this topic. It has been closed.

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.