select id1 as 'Name',count(id1) as 'count' from table1
从数据库取得的数据形式如下:
Name count
电影-1 10
电影-2 20
电影-3 30
... ...
... ...
... ...
体育-1 10
体育-2 20
体育-3 30
... ...
... ...
... ...
游戏1 10
游戏2 20
游戏3 30
...
现在想得到的数据形式是这样的:
Name count
电影 60
体育 60
游戏 60
Sql语句该怎么写啊!!!求大侠们帮忙,俺脑袋笨,弄了半天弄不出来......
从数据库取得的数据形式如下:
Name count
电影-1 10
电影-2 20
电影-3 30
... ...
... ...
... ...
体育-1 10
体育-2 20
体育-3 30
... ...
... ...
... ...
游戏1 10
游戏2 20
游戏3 30
...
现在想得到的数据形式是这样的:
Name count
电影 60
体育 60
游戏 60
Sql语句该怎么写啊!!!求大侠们帮忙,俺脑袋笨,弄了半天弄不出来......
Name,SUM(count) AS count
FROM
(SELECT
id1 as Name,
count(id1) as count
FROM table)A
GROUP BY Name
select left(Name,2) as Name,sum(count)
from 表
group by left(Name,2)
SELECT
left(Name,2) as name,SUM(count) as count AS count
FROM
(SELECT
id1 as Name,
count(id1) as count
FROM table)A
GROUP BY Name
group by left(Name,2)
from table1
group by Name
楼主说说。不会表里面的数据都是“电影-1”这之类的数据吧?
Name count
武林外传-1 10
武林外传-2 10
武林外传-3 10
武林外传-4 10
...
...
...倚天屠龙记-1 20
倚天屠龙记-2 20
倚天屠龙记-3 20
倚天屠龙记-4 20
倚天屠龙记-5 20
倚天屠龙记-6 20
...
可以这样SELECT
substring(name,1,charindex('-',name)-1) as name,SUM(count) as count AS count
FROM
(SELECT
id1 as Name,
count(id1) as count
FROM table)A
GROUP BY Name
group by left(Name,charindex('-',Name)-1)
顶!!!!!