5,889
社区成员
发帖
与我相关
我的任务
分享
create table test1 (
date varchar(10),
city varchar(20),
weather varchar(20)
);
insert into test1 VALUES ('2016-3-1','北京','晴');
insert into test1 VALUES ('2016-3-1','上海','晴');
insert into test1 VALUES ('2016-3-2','北京','阴');
insert into test1 VALUES ('2016-3-2','上海','阴');
insert into test1 VALUES ('2016-3-3','北京','雨');
insert into test1 VALUES ('2016-3-3','上海','阴');
insert into test1 VALUES ......
select city as 城市,
max(CASE WHEN date = '2016-3-1' THEN TEST1.weather END) as time1,
max(CASE WHEN date = '2016-3-2' THEN TEST1.weather END) as time2,
max(CASE WHEN date = '2016-3-3' THEN TEST1.weather END) as time3
--日期有几个就迭代几个,有人能想出点简单的方法没?
from TEST1 group by city;
create table test1 (
date varchar(10),
city varchar(20),
weather varchar(20)
);
insert into test1 VALUES ('2016-3-1','北京','晴');
insert into test1 VALUES ('2016-3-1','上海','晴');
insert into test1 VALUES ('2016-3-2','北京','阴');
insert into test1 VALUES ('2016-3-2','上海','阴');
select city as 城市,
max(CASE WHEN date = '2016-3-1' THEN date else '' END) as 晴 ,
max(CASE WHEN date = '2016-3-2' THEN date else '' END) as 阴
from TEST1 group by city
图片上传不了,就不截图了。
但是感觉哪里好像不对,求指点.