22,300
社区成员




select
*
from t
b
where
Year(getdate())> case when col1 > col2 then col1 else col2 end
select * from 表名 where Year(getdate())>
CASE WHEN COL1-COL2<0 THEN COL2 ELSE COL1 END
?select * from 表名
where Year(getdate())>case when 列1>列2 then 列1 else 列2 end
SELECT CASE WHEN COL1-COL2<0 THEN COL2 ELSE COL1 END FROM TB
?