-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Monday 09 February 2004 08:44, Patricio Gigoux wrote: > Hi: > How Can I do for after a query I put at the its last record?
I'm not sure I followed the question, but I think you're asking how to look at the last record in the set you just returned. If so, the easiest way is to do a descending sort. For example Assume a table as follows: Table1 ID Value -------- ---------- 1 23 2 30 3 45 Then Select * from Table1 Order by ID Desc; Will return ID Value -------- -------- 3 45 2 30 1 23 Now the *FIRST* record you will see is the last record in the set. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) iD8DBQFAJ5lEjeziQOokQnARAsmPAJ96yzc+WcieFt5cj2zMLvAIY17nSQCgh8XS rciGckLMnLCqkfvf3z+GqSU= =hwzq -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]