下面是一个例子,按 CHARLINENAME 分组,按 STOPTIME 排序,最后取分组第一个 where rn = 1
select *
from (SELECT ROW_NUMBER() OVER(PARTITION BY CHARLINENAME ORDER BY STOPTIME DESC) RN,
T.*
FROM T_STOPLINERECORD T)
where rn = 1
下面是一个例子,按 CHARLINENAME 分组,按 STOPTIME 排序,最后取分组第一个 where rn = 1
select *
from (SELECT ROW_NUMBER() OVER(PARTITION BY CHARLINENAME ORDER BY STOPTIME DESC) RN,
T.*
FROM T_STOPLINERECORD T)
where rn = 1