SELECT * FROM 表名 INNER JOIN [SELECT 表名.name, MAX(表名.date) AS tMaxDate FROM 表名 GROUP BY 表名.tClientID]. AS 表名2 ON 表名2.name= 表名.name AND 表名2.date= 表名.date这样看看
select name,max(date) from table group by name
SELECT TOP 1 * FROM tb ORDER BY date DESC
select name,max(date) from table group by name order by name
[SELECT 表名.name, MAX(表名.date) AS tMaxDate FROM 表名 GROUP BY 表名.tClientID]. AS 表名2
ON
表名2.name= 表名.name AND 表名2.date= 表名.date这样看看
group by name
group by name
order by name