查询一个表，把对应的行转列怎么写？

2017-08-04 02:17:06 318 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

【MySQL】多表查询,事务 & 行转列,列转行练习 MySQL多表查询&事务多表查询事务 DCL 多表查询： * 查询语法： select 列名列表 from 表名列表 where.... * 准备sql # 创建部门表 CREATE TABLE dept( id INT PRIMARY KEY AUTO_INCREMENT, NAME VARCHAR(20) ); INSERT INTO dept (NAME) VALUES ('开发部'),('市场部'),('财务部'); # 创建员工表 CR 阅读详情



select t1.deriveno, t1.carno, t1.begintime, t2.endtime

  from (select deriveno, carno, actualtime begintime

          FROM (select a.deriveno,

                       a.carno,

                       a.stagecode,

                       to_char(a.actualtime, 'yyyy-mm-dd hh24:mi:ss') as actualtime

                  from app_carstatus a, app_send b

                 where a.deriveno = b.deriveno

                   and b.status in ('0', '10')

                   and b.deriveno not in (select deriveno from app_ridecost))

         where stagecode = '3') t1

  left join (select deriveno, actualtime endtime

               from (select a.deriveno,

                            a.carno,

                            a.stagecode,

                            to_char(a.actualtime, 'yyyy-mm-dd hh24:mi:ss') as actualtime

                       from app_carstatus a, app_send b

                      where a.deriveno = b.deriveno

                        and b.status in ('0', '10')

                        and b.deriveno not in

                            (select deriveno from app_ridecost))

              WHERE STAGECODE = '4') t2

on t1.deriveno = t2.deriveno