MS SQL排序語法 @ 歡迎~ 程式設計 學生 作業 專題製作 程式外包 家教... :: 痞客邦 PIXNET ::
MS-SQL 2005以後才有RANK()語法。 SELECT * FROM ( SELECT rank() OVER ( ORDER BY [排序欄位] [ASC/DESC] ) AS RankNumber, * FROM ( SELECT [欄位1, 欄位2, ...] FROM [資料表] WHERE [篩選條件] ) AS [資料表别名1] WHERE RankNumber ......