我的数据库 name data date 张 5 2001-1-1 李 6 2002-1-1 王 7 2003-1-1 请问sql查询 select name,max(data),date from database group by name 会出现错误,又不能用group by name,date,因为我的date不要分 我要查出最大data的所有字段
----------------------------------------------
-
select a.name,a.maxdata,b.date from (select name,max(data) as maxdata from database group by name) as a,database as b where (a.name=b.name)
----------------------------------------------
-