如何过虑重复记录
现在有这样一个表tbl1:
idnameactionuptime1张三a12009-2-32大一b12009-2-43王二c12009-2-54小明d12009-2-65张三a22009-2-76张三a32009-2-87大一b22009-2-108小明d22009-2-99小明d32009-2-11
过滤后返回集为：
1张三a32009-2-82大一b22009-2-103王二c12009-2-54小明d32009-2-11
请问这个sql语句该我如何写呢？ Easy!
select a.*
from tab1 a,
(select max(id) as idfrom tab1 group by name) b
where a.id=b.id;
页:
[1]