从PhpMyAdmin获取最长年份的记录

Question

I have below table

+--------------+-----------+
| serial no    |  isNew    |
+--------------+-----------+
| 630401A      |  2014     |
| 630401B      |  2014     |
| 630401A      |  2013     |
| 630401B      |  2013     |
| 630401C      |  2013     |
+--------------+-----------+

Now the thing is I want to select records as per isNew column. As you can see that serial no is same and isNew is different in 2 cases and in on case there is only record for serial number.

So I want output like

+--------------+-----------+
| serial no    |  isNew    |
+--------------+-----------+
| 630401A      |  2014     |
| 630401B      |  2014     |
| 630401C      |  2013     |
+--------------+-----------+

I hope I am very clear to display my table and result I want.

Thanks for your help in advance!

Answer 1

select * from TABLENAME group by serialno order by isNew DESC