-----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]

Reply via email to