對于每個主題，我想在特定日期之后過濾他們的記錄。但是，我想用作過濾器的日期因每個主題而異。有沒有辦法按主題分組然后為每個組使用不同的 have 子句？
uj5u.com熱心網友回復：
你可以這樣做：
select tbl.subject
,count(*) as record_count
-- add other aggregate functions as required
from thetable tbl
join (values
('somesubject' ,'2005-04-03')
,('othersubject','2008-07-06')
,('yetanother' ,'2013-12-11')
-- add as many subjects as required
) cutoff(subject,min_dt) on cutoff.subject = tbl.subject and cutoff.min_dt::date <= tbl.date_column
group by tbl.subject
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/317114.html