【【【请教大神们一条SQL语句】】】

[jauia]

表：city

id | city_id | title
1 | 1 | xx
2 | 2 | xxx
3 | 3 | xxxxx
4 | 1 | x x x
5 | 2 | x x x x
6 | 2 | x x x x

要想的显示结果是：
city_id | count(title)
1 | 2
2 | 3
3 | 1

根据这张表，显示出不同city_id的title个数.

请大神们指教！

[jauia]

郁闷，刚发完问题，自己写出来了..

[呆到深处自然萌2]

[Quote=引用 1 楼 jauia 的回复:]
郁闷，刚发完问题，自己写出来了..
[/Quote]

[呆到深处自然萌2]

declare @a table(id int,city_id int,title varchar(10))
insert into @a
select 1,1,'xx'   union all
select 2,2,'xxx'  union all
select 3,3,'xxxx' union all
select 4,1,'xxx'  union all
select 5,2,'xxxx' union all
select 6,2,'xxxx'  

select * from @a
select distinct city_id,count(title) as [count(title)]  from @a group by city_id;