The difference for ROW_NUMBER/RANK/DENSE_RANK/NTILE
摘要：USE tempdbGOCREATE TABLE Table1( ID INT IDENTITY(1,1) NOT NULL, UserID INT NOT NULL)GOINSERT INTO Table1(UserID)SELECT 1UNION ALLSELECT 1UNION ALLSELECT 3UNION ALLSELECT 4UNION ALLSELECT 5GOSELECTUserID,ROW_NUMBER()OVER(ORDER BY UserID) AS RowNumberID,RANK()OVER(ORDER BY UserID) AS RankID,DENS...
阅读全文
posted @ 2012-02-05 21:32
