Q: MySQL query to get nested MAX() Values My table look like the following. 
-----------------------------------
|    DATE       |    SERIAL_NO    | 
-----------------------------------
| 2014-01-01    |      10001      |
| 2014-01-01    |      10002      |
| 2014-01-01    |      10003      |
| 2014-01-01    |      10004      |
| 2014-01-03    |      10001      |
| 2014-01-03    |      10002      |
| 2014-01-03    |      10003      |
| 2014-01-03    |      10004      |
| 2014-01-02    |      10001      |
| 2014-01-02    |      10002      |
| 2014-01-02    |      10003      |
| 2014-01-02    |      10004      |
-----------------------------------

From here I need to write the MySQL query to get the MAX(DATE) and for the maximum date I have to get the MAX(SERIAL_NO). 
Thanks in advance.

A: Select date, serial_no from myTable order by date desc, serial_no desc limit 1;


A: Select date, max(serial_no) from myTable where date = (select max(date) from myTable)

