对group by 选取结果的排序

user_info表

假设该表中数据：

id             num               user_id            createtime

1                3514                   2                 2011-09-28 16:04:22

2                 4000                  2                 2011-09-28 16:04:42 

3                 3333                  123            0000-00-00 00:00:00

4                 3333                   32              2011-10-28 16:04:42

5                 1000                    32             2011-09-28 16:04:23

 假设现在要获取每个不同user_id对应的createtime最新的记录，即

 2                 4000                  2                 2011-09-28 16:04:42

3                 3333                  123            0000-00-00 00:00:00

4                 3333                   32              2011-10-28 16:04:42

执行语句可以为：

select * from (select * from user_info order by createtime desc) t group by user_id;