再求个sql语句

[sdyqingdao]

table tblProducts有两个字段：
....
MSRP int
M_Price int
......

现在我要找出符合MSRP>66 and MSRP<70的M_Price的每个不同值的个数，比如查询得到：
M_Price
75
75
68
null
74
75
76
null

则应该得到1个68，1个74，3个75，1个76。null值被忽略掉

请教sql语句？

[Garnett_KG]

SELECT M_Price,COUNT(M_Price) as cnt
FROM tblProducts
WHERE M_Price>66 AND M_Price<70
GROUP BY M_Price

[aaajedll]

SELECT M_Price,COUNT(M_Price) as cnt
FROM tblProducts
WHERE M_Price>66 AND M_Price<70 and M_Price is not null
GROUP BY M_Price

[internetroot]

select distinct m_price from tblProducts where MSRP>66 and MSRP <70

[aaajedll]

SELECT M_Price,COUNT(M_Price) as cnt
FROM tblProducts
WHERE M_Price>66 AND M_Price<70 and M_Price is not null
GROUP BY M_Price

[internetroot]

select distinct m_price from tblProducts where MSRP>66 and MSRP <70

[aaajedll]

SELECT M_Price,COUNT(M_Price) as cnt
FROM tblProducts
WHERE M_Price>66 AND M_Price<70 and M_Price is not null
GROUP BY M_Price

[internetroot]

晕，看错题意了
是这样
SELECT M_Price,COUNT(M_Price) as cnt
FROM tblProducts
WHERE M_Price>66 AND M_Price<70
GROUP BY M_Price

[幸运的意外]

declare @sql varchar(8000)
select
@sql=isnull(@sql+ ',','') + 'case when M_Price=' + cast(M_Price as varchar(10)) + ' then count(M_Price) end as [' + cast(M_Price as varchar(10)) + '] ' +char(13)
from
@tb
set @sql='select ' +@sql + 'from @tb where MSRP>60 and MSRP<70 group by M_Price'
exec (@sql)

[ws_hgo]

select M_Price 
sum (case when M_Price>66  and M_Price<70) as '次数'
from tblProducts group by M_Price

随手写的
思路是这样的

[ChinaITOldMan]

SELECT M_Price,COUNT(M_Price) as cnt
FROM tblProducts
WHERE M_Price>66 AND M_Price<70
GROUP BY M_Price
和
select M_Price
sum (case when M_Price>66 and M_Price<70) as '次数'
from tblProducts group by M_Price
都不错

[fzcheng]

SELECT M_Price,COUNT(M_Price) as cnt
FROM tblProducts
WHERE M_Price>66 AND M_Price<70
GROUP BY M_Price

[xingyanguang0433]

他想要的是这样的
"每个不同值的个数" count(distinct M_Price)

[fcuandy]

select price,count(*) from tb where price between x and y
group by price