CREATE TABLE #MYTAB (CODE INT NOT NULL, [NAME] VARCHAR(100) NOT NULL)INSERT INTO #MYTAB VALUES(1,'SADFA') INSERT INTO #MYTAB VALUES(2,'TYBTY') INSERT INTO #MYTAB VALUES(3,'FTJNI') INSERT INTO #MYTAB VALUES(3,'R6K57K') INSERT INTO #MYTAB VALUES(1,'W34546') INSERT INTO #MYTAB VALUES(1,'BR67')
select a.* from tablename a join ( select 编号, count(*) as 行数 from tablename group by 编号 ) b on a.编号=b.编号 order by 行数 desc
(CODE INT NOT NULL,
[NAME] VARCHAR(100) NOT NULL)INSERT INTO #MYTAB
VALUES(1,'SADFA')
INSERT INTO #MYTAB
VALUES(2,'TYBTY')
INSERT INTO #MYTAB
VALUES(3,'FTJNI')
INSERT INTO #MYTAB
VALUES(3,'R6K57K')
INSERT INTO #MYTAB
VALUES(1,'W34546')
INSERT INTO #MYTAB
VALUES(1,'BR67')
from tablename a join
( select 编号, count(*) as 行数
from tablename
group by 编号
) b
on a.编号=b.编号
order by 行数 desc
不知道有什么方法能在一条SQL中实现~