[SQL Server 2017-SSMS] WITH AS、 ROW_NUMBER()、PARTITION BY查詢的資料變化

整個語法如下：
WITH TETABLE AS
(
SELECT [TraTitle],[TraDate],[TraTime],[TraNum],[TraContent], ROW_NUMBER() OVER (PARTITION BY [TraTitle],[TraDate],[TraTime],[TraNum],[TraContent] ORDER BY [TraTitle]) AS SORT
 FROM
 [dbo].[ForeignTra]
)
SELECT [TraTitle],[TraDate],[TraTime],[TraNum],[TraContent],SORT
FROM TETABLE WHERE SORT>1


查詢的資料變化如下：
1.

2.

3.

4.

以上方便以後參考。