取重复数据 在线等

[luluyy]

列1    列2      列3       名称     规格      列6
 1        2           4          b        100      6
 3        7           9          b         200      9
 8        9           5          c         100      7
 5        6           3          c         100     9

sql语句 从上个表A中根据列4与列5两个条件取出重复数 并计算出各种重复的有多少条

得出的结果如下

条数 名称 规格
1 b 100
1 b 200
2 c 100

[卖水果的net]

-- ?? 
select  名称      , 规格 , count (*) as 条数
from t 
group by  名称     ,  规格

[qq_17144723]

select count(t.*) as 条数,t.名称,t.规格 from (select distinct 名称,规格 from 表A) as t group by t.名称,t.规格

[qq_17144723]

select 1 as a, 2 as b, 4 as c, 'b' as name, 100 as spec, 6 as f into table1 select * from table1 insert into table1(a,b,c,name,spec,f) select 3, 7, 9, 'b', 200, 9 union all select 8, 9, 5, 'c', 100, 7 union all select 5, 6, 3, 'c', 100, 9 select * from table1 select count(*) as numcount,name,spec from table1 group by name,spec order by name,spec drop table table1