我希望在使用 where 子句過濾時對輸出進行排序。我嘗試按檔案名排序，但它給出了 loc1-2main%'、'loc1-2branch%'、'loc2-3main%'、'loc3-4main%'。這不是我想要的
select distinct fi.description as "Status", fi.filename,MAX(fi.createddate) AS "latestentry"
from fileimport fi
AND fi.filename LIKE ANY(ARRAY[['loc1-2main%', 'loc2-3main%', 'loc3-4main%', 'loc1-2branch%']])
GROUP BY fi.filename, c2.description
uj5u.com熱心網友回復：
將where子句放在order子句中
select distinct fi.description as "Status", fi.filename,MAX(fi.createddate) AS "latestentry"
from fileimport fi
where fi.filename LIKE ANY(ARRAY[['loc1-2main%', 'loc2-3main%', 'loc3-4main%', 'loc1-2branch%']])
group by fi.filename, c2.description
order by fi.filename LIKE ANY(ARRAY[['loc1-2main%', 'loc2-3main%', 'loc3-4main%', 'loc1-2branch%']])
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/415507.html
標籤：
上一篇：根據條件組合表中的各種行