;WITH x AS ( SELECt ID, NAME, [DATE], rn = ROW_NUMBER() OVER (PARTITION BY NAME ORDER BY [DATE] DESC) FROM @TESTABLE)SELECt ID, NAME, [DATE] FROM x WHERe rn = 1 ORDER BY [DATE] DESC;
尽量避免使用保留字（和模糊的列名），例如
[DATE]…
;WITH x AS ( SELECt ID, NAME, [DATE], rn = ROW_NUMBER() OVER (PARTITION BY NAME ORDER BY [DATE] DESC) FROM @TESTABLE)SELECt ID, NAME, [DATE] FROM x WHERe rn = 1 ORDER BY [DATE] DESC;
尽量避免使用保留字（和模糊的列名），例如
[DATE]…
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
