axgle
中级会员
 
中级会员
UID 62667
精华
0
积分 486
帖子 461
金钱 486 喜悦币
威望 0
人脉 0
阅读权限 30
注册 2004-12-23
状态 离线
|
挑战seakingx
题目在这里
http://www.phpx.com/happy/thread-132950-1-2.html
seakingx的答案:
select sum(A0) as `海南` , sum(A1) as `广东` , sum(A2) as `北京` , manager from (
select 1 as A0 , 0 as A1 , 0 as A2 , `manager` FROM rel1 WHERE area like '海南%'
union all
select 0 as A0 , 1 as A1 , 0 as A2 , `manager` FROM rel1 WHERE area like '广东%'
union all
select 0 as A0 , 0 as A1 , 1 as A2 , `manager` FROM rel1 WHERE area like '北京%'
) A
group by manager;
我的答案如下:
select sum(area like '海南%') as `海南`,
sum(area like '广东%') as `广东`,
sum(area like '北京%') as `北京`,manager from rel1 group by manager
  
[ 本帖最后由 axgle 于 2007-5-8 02:19 PM 编辑 ]
|
|
