SQL查询语句合并相同项并计算记录条数。急！！！在线等···
ID Name PID TYPE
2.NET方向6380
2.NET方向6400
2.NET方向6450
2.NET方向6810
366空口烟10290
366空口烟10320
366空口烟11320
366空口烟11330
366空口烟11380
366空口烟11390
366空口烟10400
388TEST011711660
399市场营销111470
399市场营销123090
399市场营销123080
400323啊a_3f312740
400323啊a_3f311460
400323啊a_3f312860
401yyyu13820
401yyyu13930
401yyyu14030
401yyyu14040
406test12410
想得到如下的结果：
ID Name PID TYPE COUNT
2.NET方向6380 4
366空口烟10290 7
388TEST011711660 1
399市场营销111470 3
400323啊a_3f312740 3
401yyyu13820 4
406test12410 1
最后最好可以按照COUNT降序排列！急！！！ 在线等
[解决办法]
select ID,Name,min(PID) as PID,Type,Count(1) from table1 group by ID,Name,Type
[解决办法]
select ID,Name, PID ,TYPE,Count(*) as [Count]
from T
group by ID,Name, PID ,TYPE
order by Count(*) as [Count]
[解决办法]
select ID,Name, PID ,TYPE,Count(*) as [Count]
from T
group by ID,Name, PID ,TYPE
order by Count(*) as [Count] desc
[解决办法]
select ID ,Name ,min(PID) PID, min(TYPE) TYPE, COUNT(1) [count] from tb group by ID ,Name order by [count] desc
