T-SQL查询： TOP N [PERCENT] WITH TIES ORDER BY 顺序排序实例

USE tempdb
GO

--DROP TABLE #TEST
CREATE TABLE #TEST(DEPTNAME VARCHAR(50),AMOUNT INT)CREATE TABLE #TES