sql中类似三元运算符的语句

SELECT ( CASE WHEN DATENAME(QUARTER, GETDATE()) = 1
THEN DATENAME(YEAR, DATEADD(YEAR, -1, GETDATE()))
ELSE DATENAME(YEAR, GETDATE())
END );

原文地址:https://www.cnblogs.com/g120/p/6281591.html