如何按组中的其他列排序？

I have the following articles mysql table:

id | date
 1 | 2013-02-16 00:00:00
 2 | 2013-02-17 00:00:00

I want to get a comma separated list of the ids (1,2) and the last date value (2013-02-17 00:00:00)

I use the following query:

SELECT GROUP_CONCAT(id),date FROM articles ORDER BY date DESC

The query selects the first date value it encounters (2013-02-16 00:00:00), how to make it select the last one instead?

Thanks

select group_concat(id), 
       max(date) as max_date
from your_table

use this:

SELECT GROUP_CONCAT(id),date FROM articles ORDER BY date ASC

What about use MAX:

SELECT GROUP_CONCAT(id),MAX(date) 
FROM articles