select * from 表 t1 where 异动时间 = (select max(异动时间) from 表 where 姓名 = t1.姓名 group by 姓名)
select B.* from ( select name ,max([date]) as 'date' from 表 group by name )A join 表 B on A.name=B.name order by B.name
select B.* from ( select name ,max([date]) as 'date' from 表 group by name )A join 表 B on A.name=B.name and A.[date]=B.[date] order by B.name
select B.* from ( select name ,max([date]) as 'date' from 表 group by name )A join 表 B on A.name=B.name and A.[date]=B.[date] order by B.nameor: select * from 表 A where not exists( select * from 表 B where a.name=b.name and a.code=b.code and b.date>a.date )
select B.* from ( select name ,max(date) from tb group by name )A join tb B on A.name=B.name and A.[date]=B.[date] order by B.name 也就是这样了,除非有特别的新奇的东西。
select t.* from 表 t where not exists(select 1 from 表 where name=t.name and [date]>t.[date])
where 异动时间 = (select max(异动时间) from 表 where 姓名 = t1.姓名 group by 姓名)
from (
select name
,max([date]) as 'date'
from 表
group by name
)A
join 表 B on A.name=B.name
order by B.name
from (
select name
,max([date]) as 'date'
from 表
group by name
)A
join 表 B on A.name=B.name
and A.[date]=B.[date]
order by B.name
from (
select name
,max([date]) as 'date'
from 表
group by name
)A
join 表 B on A.name=B.name
and A.[date]=B.[date]
order by B.nameor:
select * from 表 A
where not exists(
select * from 表 B
where a.name=b.name and a.code=b.code and b.date>a.date )
from (
select name
,max(date)
from tb
group by name
)A
join tb B on A.name=B.name
and A.[date]=B.[date]
order by B.name
也就是这样了,除非有特别的新奇的东西。