|
うちの母ちゃんに依頼された実例です。なす、ピーマン、かぼちゃについては、()無しと(露地栽培)のみということで、検索条件で全て列挙する方式です。
select yoto, shurui, tsusho,
max(case when sakumotsu like "なす%" then jiki||"、 "||kaisu else "" end) as nasu,
max(case when sakumotsu like "ピーマン%" then jiki||"、 "||kaisu else "" end) as pman,
max(case when sakumotsu like "かぼちゃ%" then jiki||"、 "||kaisu else "" end) as kabocha,
max(case when sakumotsu = "にがうり" then jiki||"、 "||kaisu else "" end) as goya,
max(case when sakumotsu = "オクラ" then jiki||"、 "||kaisu else "" end) as okura
from tekiyo where
(yoto like "殺虫%" or yoto like "%殺菌剤") and hoho = "散布" and shurui not like "%粉剤" and shurui not like "%粒剤" and
sakumotsu in ("なす", "なす(露地栽培)", "ピーマン", "ピーマン(露地栽培)", "かぼちゃ", "かぼちゃ(露地栽培)", "にがうり", "オクラ")
group by tsusho order by yoto, shurui, tsusho
|
|