韩后精华水多少钱:这个SQL语句怎么写?

code name price
1 beijing 100
10 beijing 500
2 shanghai 300
20 shanghai 700

select T1.name,price1,price2 from
(select code, name, sum(price) as price1 from price where code = 1 group by code,name ) as T1
inner join ( select code , name, sum(price) as price2 from price where code =10 group by code , name ) as T2
on T1.name = T2.name
union
(select T1.name,price1,price2 from
(select code, name, sum(price) as price1 from price where code = 2 group by code,name ) as T1
inner join ( select code , name, sum(price) as price2 from price where code =20 group by code , name ) as T2
on T1.name = T2.name
)
搞定！解释：
在程序里用循环语句在每一个inner join 处遍历code=莫个值的所有情况
这样就能实现遍历所有这个code值的所有字段加在一起
在每一个union处 遍历表里name的所有值！这样就能把所有情况加在一个表里

select *
from 表名
where （名称＝北京 and 金额＝300 400 600）or
(名称＝上海 and 金额＝300 500 700)
麻烦您最好把中文名字改成英文。否则输入中文名两端还要加％

select 后面应该是你最终要显示的那些项.
条件是先按地方分组,再按代码分组就应该可以实现.

代码编号重复最大数
SELECT count(*) FROM [表] GROUP BY 编码 HAVING count(*)>1

代码名称不重复总数
SELECT count(*) FROM [SELECT DISTINCT 名称 FROM 表]. AS get_x_num

一时想不到怎么循环，能加我QQ，一起研究吗
QQ: 105187501
注明 是百度来的