同一个表中相字段的数量统计

[ZMAK_Chun]

表Tb
id U_ID P_ID price
1 2 1 10
2 1 1 10
3 3 1 12
4 3 2 44
5 5 2 45
6 1 2 45
如何得到以下结果
P_ID price count
1 10 2
1 12 1
2 44 1
2 45 2
就是各种商品相同出价的次数~
谢谢各位 ~！

[dawugui]

select P_ID      ,           price  , count(1) from tb group by P_ID      ,           price 

[dawugui]

create table tb(id int, U_ID int, P_ID int, price int)
insert into tb values(1 , 2 , 1 , 10 )
insert into tb values(2 , 1 , 1 , 10 )
insert into tb values(3 , 3 ,1 , 12 )
insert into tb values(4 , 3 , 2 , 44 )
insert into tb values(5 , 5 , 2 , 45 )
insert into tb values(6 , 1 , 2 , 45 )
go

select P_ID , price , count(1) [count] from tb group by P_ID , price 

drop table tb

/*
P_ID        price       count       
----------- ----------- ----------- 
1           10          2
1           12          1
2           44          1
2           45          2

（所影响的行数为 4 行）


*/

[zhangjiang264]

select P_ID,price,count(*) as count
from Tb
group by P_ID,price

[老黎]

--up
--帮忙排版下
select P_ID, price, [count] = count(1) 
from tb 
group by P_ID, price 

[GUOCHENGJUN]

[Quote=引用 2 楼 dawugui 的回复:]
SQL code
create table tb(id int, U_ID int, P_ID int, price int)
insert into tb values(1 , 2 , 1 , 10 )
insert into tb values(2 , 1 , 1 , 10 )
insert into tb values(3 , 3 ,1 , 12 )
insert into tb ……
[/Quote]
up