Hi,
i've a table in a mysql database.
It has a lot of field and three of them are:
* A counter: IDTable
* A date: DateFaxInsert
* A Number: NumberFaxInsert
I want to obtain the last and the last - 1 IDTable.
If i write:
SELECT MAX(IDTable) AS IDMax, DateFaxInsert, NumberFaxInsert FROM
FaxServer GROUP BY DateFaxInsert
is ok but i would like to see MAX and MAX-1 of IDTable...
Any idea please?
Thanks :-)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]