select tId,tName,tType,endTime
from
(select tId,tName,tType,endTime,
row_number() over(partition by tType order by endTime desc) rn
from test1) a
where rn<=2
select tId,tName,tType,endTime
from
(select tId,tName,tType,endTime,
row_number() over(partition by tType order by endTime desc) rn
from test1) a
where rn<=2
转载于:https://my.oschina.net/i33/blog/65006