Heim > Fragen und Antworten > Hauptteil
P粉5614384072023-08-11 12:52:37
根据所给的信息,也许这个版本可能有所帮助:
SELECT * FROM table1 AS p WHERE (CASE WHEN p.accepted_date_key > '11082023' THEN 1 WHEN p.voided_date_key = '11082023' THEN p.oldversionref ELSE 0 END) = 1;