计算ROW_NUMBER
后UNION
。
SELECT *, ROW_NUMBER() OVER (PARTITION BY StaffNumber ORDER BY STARTTIME DESC) AS rn
FROM (
SELECT * FROM T1
UNION ALL
SELECT * FROM T2
) x
我怀疑你需要UNION ALL
。
Row_Number()在分区上-更简单的方法
计算ROW_NUMBER
后UNION
。
SELECT *, ROW_NUMBER() OVER (PARTITION BY StaffNumber ORDER BY STARTTIME DESC) AS rn
FROM (
SELECT * FROM T1
UNION ALL
SELECT * FROM T2
) x
我怀疑你需要UNION ALL
。