重复数据统计提取 有表TB1,字段a,b,c,d,表中存在大量重复数据,现在想从表中提取部分数据插入TB2中,条件是:其重复的次数在前10名,即:提取出来的数据只有10条,并且它们在TB1中重复的次数排在所有数据重复次数的前10名.请大虾们帮我一下,先谢谢! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 INSERT TB2SELECT TOP 10 A,B,C,DFROM (SELECT A,B,C,D.COUNT(1) AS CNT FROM TB1 GROUP BY A,B,C,D)TORDER BY CNT DESC insert tb2 select top 10 a,b,c,d from tb1 group by a,b,c,dorder by count(*) desc insert into tb2 select top 10 *from (select a,b,c,d,count(1) as num from tb 1 group by a,b,c,d)torder by num descwhere insert into tb2 select top 10 *from (select a,b,c,d,count(1) as num from tb 1 group by a,b,c,d)torder by num desc select top 10 A,B,C,Dfrom TB1group by A,B,C,Dorder by count(*) desc 请教一个基础性问题 MRP运算后的订单跟踪 简化两条SQL语句,本人新手 储存过程 循环读取数据并保存数据 问个很棘手的问题!!!!!!!!!1 关于SQL2008外网登陆输入服务器名称问题 一个简单的关于事务日志的问题。。。 加密技术 SQL语句的问题 SQL Server 2000的关系图打印旁边总是空得很大,A4的纸更本没法一张打出全部。怎么办? 想好好学学sqlServer设计及sql语句优化大家给推荐几本书,要中文的。 关于数据表复制到另外一个数据表
SELECT TOP 10 A,B,C,D
FROM
(SELECT A,B,C,D.COUNT(1) AS CNT FROM TB1 GROUP BY A,B,C,D)T
ORDER BY CNT DESC
select top 10 a,b,c,d from tb1 group by a,b,c,d
order by count(*) desc
tb2
select
top 10 *
from
(select a,b,c,d,count(1) as num from tb 1 group by a,b,c,d)t
order by num desc
where
tb2
select
top 10 *
from
(select a,b,c,d,count(1) as num from tb 1 group by a,b,c,d)t
order by num desc
from TB1
group by A,B,C,D
order by count(*) desc