查询所有订单的最新信息的SQL语句的写法 DISTINCT配合count和group by一起完成

场景：每个订单会持续更新，客户需要能查看每次更新的内容，所以每次更新我都会存一次，而不是在原来的基础上更新。

现在需要查看每个订单的最新信息。

SELECT *,count(DISTINCT ordernum) FROM xxxx group by ordernum order by addtime desc

Array
(
    [0] => Array
        (
            [id] => 24
            [userid] => 3
            [ordernum] => 1305090124
            [is_completed] => 1
            [card] => BBJ
            [totaltime] => 100
            [usedtime] => 
            [addtime] => 1368088986
            [filter_flag] => 201305
            [is_read] => 0
            [count(DISTINCT ordernum)] => 1
        )

    [1] => Array
        (
            [id] => 20
            [userid] => 3
            [ordernum] => 13042