資料庫格式：
想要的查詢結果：
我用case when可以做，但是結果會出現三行，有沒有可以生成一行的辦法
uj5u.com熱心網友回復：
試下 left joinuj5u.com熱心網友回復：
select
at1.A as '2019A',
at1.B as '2019B',
at1.C as '2019C',
at2.A as '2018A',
at2.B as '2018B',
at2.C as '2018C',
at3.A as '2017A',
at3.B as '2017B',
at3.C as '2017C',
at4.A as '2016A',
at4.B as '2016B',
at4.C as '2016C'
from at as at1
left join at as at2 on at1.Datetime <> at2.Datetime
left join at as at3 on at2.Datetime <> at3.Datetime
left join at as at4 on at3.Datetime <> at4.Datetime
where at1.Datetime = 2019 and at2.Datetime = 2018 and at3.Datetime = 2017 and at4.Datetime = 2016
uj5u.com熱心網友回復：
明白了，多謝各位老哥轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/15020.html
標籤：MySQL