特殊sql语句

1.

按client_id分组，查询每个client_id中离目前时间最近的记录。

查询结果示意

idclient_idaddtime312012-03-26 10:32:30722012-03-26 10:30:341132012-03-26 10:30:38942012-03-26 10:30:36

SELECT * FROM (SELECT * FROM client_status ORDER BY addtime DESC )a GROUP BY client_id

判断name字段是否有重复数据：select count(*) num,name FROM user group by name having num>1