count在哪?.select * from tt order by number desc,name
count 还是 number? 如果是number: order by number desc,name
SELECT * FROM (SELECT *, RN = ROW_NUMBER() OVER(PARTITION BY COUNT ORDER BY NAME) FROM TT)
select * from tt order by number desc,name desc
IF OBJECT_ID('TT') IS NOT NULL DROP TABLE TTCREATE TABLE TT(ID INT, NAME VARCHAR(2))INSERT INTO TT SELECT 3, '02' UNION ALL SELECT 2, '01' UNION ALL SELECT 3, '01' UNION ALL SELECT 1, '02' UNION ALL SELECT 2, '02' UNION ALL SELECT 1, '01' UNION ALL SELECT 1, '03'SELECT ID, NAME FROM (SELECT *, RN = ROW_NUMBER() OVER(PARTITION BY ID ORDER BY NAME) FROM TT) TEMP
select * from tt order by number desc , name
如果是number:
order by number desc,name
SELECT * FROM (SELECT *, RN = ROW_NUMBER() OVER(PARTITION BY COUNT ORDER BY NAME) FROM TT)
IF OBJECT_ID('TT') IS NOT NULL
DROP TABLE TTCREATE TABLE TT(ID INT, NAME VARCHAR(2))INSERT INTO TT
SELECT 3, '02' UNION ALL
SELECT 2, '01' UNION ALL
SELECT 3, '01' UNION ALL
SELECT 1, '02' UNION ALL
SELECT 2, '02' UNION ALL
SELECT 1, '01' UNION ALL
SELECT 1, '03'SELECT ID, NAME FROM (SELECT *, RN = ROW_NUMBER() OVER(PARTITION BY ID ORDER BY NAME) FROM TT) TEMP
select * from tt order by number desc,name