34,593
社区成员
发帖
与我相关
我的任务
分享
select 名称,min(时间),max(时间) from 表 group by 名称
比较直观
select [Name],max([Date]) as date
from Tb
group by [Name]
--若是很多字段,不适合group by,则可使用Row_Number()
select [Name],[Date]
from (
select [Name],[Date]
,row_number()over(partition by [Name] order by [Date] desc) as sn
from Tb
) as t
where t.sn=1
select name,startdate,max(enddate) from
(
select a.name,min(a.rdate) startdate,b.rdate enddate from t_yp a,t_yp b where a.name = b. name and a.rdate <= b.rdate group by a.name,b.rdate
) t
group by name,startdate