create table tb(bc varchar(10),cs int )
insert into tb values('01', 1 )
insert into tb values('01', -5 )
insert into tb values('01', -7 )
insert into tb values('02',2 )
insert into tb values('02', 4 )
insert into tb values('03',1 )
insert into tb values('04',5 ) go SELECT bc
FROM tb
WHERE bc=(SELECT TOP 1 bc
FROM
(
SELECT bc,COUNT(*) AS cnt
FROM tb
GROUP BY bc
) AS t
ORDER BY cnt DESC)DROP TABLE tb/*
bc
----------
01
01
01(3 行受影响)
*/
insert into tb values('01', 1 )
insert into tb values('01', -5 )
insert into tb values('01', -7 )
insert into tb values('02',2 )
insert into tb values('02', 4 )
insert into tb values('03',1 )
insert into tb values('04',5 ) go SELECT bc
FROM tb
WHERE bc=(SELECT TOP 1 bc
FROM
(
SELECT bc,COUNT(*) AS cnt
FROM tb
GROUP BY bc
) AS t
ORDER BY cnt DESC)DROP TABLE tb/*
bc
----------
01
01
01(3 行受影响)
*/
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货