根据数据库表里的记录,查询重复记录最多次的记录-技术开发专区

根据数据库表里的记录,查询重复记录最多次的记录

作者：ITPUB论坛编辑： nancy 2008-07-07 00:00

【IT168技术文档】

select top(1)*
from num
where
value=(select value from
(select count(value) as b,value from num group by value)
as bb
where
bb.b=(select max(b) from
(select count(value) as b,value from num group by value) as dd))
法二：
SELECT TOP 1 *
FROM (SELECT value, COUNT(value) AS c
FROM num
GROUP BY value) DERIVEDTBL
ORDER BY c DESC

关注我们