![T-SQL查询： TOP N [PERCENT] WITH TIES ORDER BY 顺序排序实例](/uploads/reation/bcimg7.png)
T-SQL查询： TOP N [PERCENT] WITH TIES ORDER BY 顺序排序实例
USE tempdbGO-- DROP TABLE #TESTCREATE TABLE #TEST(DEPTNAME VARCHAR(50),AMOUNT INT)INSERT INTO #TEST(DEPTNAME,AMOUNT)VALUES ('销售1部',99), ('销售2部',100), ('销售3部',86), ('销售4部',100), ('销售5部',86)
