求一ms sql

[phoebuswei]

有结果集合
select c1 from table where c1 between A and B
集合
A
A
A
A
B
B
B
B
B
想要得到下面结果
4 A
5 B

[liangCK]

SELECT c1,COUNT(*) AS cnt
FROM [table]
WHERE c1 BETWEEN 'A' AND 'B'
GROUP BY c1

[dawugui]

[Quote=引用楼主 phoebuswei 的帖子:]
有结果集合
select c1 from table where c1 between A and B
集合
A
A
A
A
B
B
B
B
B
想要得到下面结果
4 A
5 B
[/Quote]

select count(*) , c1 from table where c1 between A and B  group by c1

[dawugui]

select count(*) , c1 from table where c1 between 'A' and 'B' group by c1

[中国风]

select c1,count(*) con from table where c1 in('A','B') group by c1

[中国风]

c1字符串沒有大小關系時用in

[phoebuswei]

需求更新
c1 是类型DateTime
要按照 没小时分组
2008-11-2-20：00
2008-11-2-20：00
2008-11-2-21：00
2008-11-2-23：00
2008-11-2-23：00
2008-11-2-23：00
结果集合
2，2008-11-2-20：00
1，2008-11-2-21：00
3，2008-11-2-23：00

[等不到来世]

[Quote=引用 6 楼 phoebuswei 的回复:]
需求更新
c1 是类型DateTime
要按照 没小时分组
2008-11-2-20：00
2008-11-2-20：00
2008-11-2-21：00
2008-11-2-23：00
2008-11-2-23：00
2008-11-2-23：00
结果集合
2，2008-11-2-20：00
1，2008-11-2-21：00
3，2008-11-2-23：00
[/Quote]

select count(*),c1
from table
group by c1

[ChinaITOldMan]

SELECT c1,COUNT(*) AS cnt
FROM [table]
WHERE c1 BETWEEN 'A' AND 'B'
GROUP BY c1

[龙扬天]

create table xc
(id int identity(1,1),c1 varchar(2))
insert into xc(c1)
select 'B'union
select 'A'union
select 'A'union
select 'A'union
select 'A'union
select 'B'union
select 'B'union
select 'B'union
select 'B'
select * from xc
1 A
2 B
3 A
4 A
5 A
6 A
7 B
8 B
9 B
select count(*) as 个数,c1 from xc group by c1
5 A
4 B

[phoebuswei]

没有能执行的，结贴