SELECT
OrderID,
Quantity,
CASE
WHEN Quantity > 30 THEN 'The quantity is greater than 30'
WHEN Quantity = 30 THEN 'The quantity is 30'
ELSE 'The quantity is under 30'
END AS QuantityStatus
FROM OrderDetails;
select
1
from table_a a
left jion
table_b b
on a.f0=b.f0
and (
case when a.fb1="scene" then a.fb2=b.fb2
else 1
end
)
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。