表中a b c d四列
if **** 取 a AS X
else
if **** 取 b AS Y
else
if **** 取 c AS Y
else 取 d AS X
执行时报错
多个if else 如何 使用啊 请教
if **** 取 a AS X
else
if **** 取 b AS Y
else
if **** 取 c AS Y
else 取 d AS X
执行时报错
多个if else 如何 使用啊 请教
begin
end
else
begin
end
else d end as columnname
begin
end
else
begin
if
begin
end
else
begin
end
end
对于不加 begin end 的,就只对if或else后面第一句作用
if ****
begin
取 a AS X
end
else
begin
if ****
begin
取 b AS Y
end
else
begin
if ****
取 c AS Y
else
取 d AS X
end
end
begin
BaseData2010.dbo.Guest.telephone1 as Y
end
ELSE
begin
BaseData2010.dbo.Guest.telephone1 as L
END)
是这么写吗
GO
SELECT
Title,
'Price Range' =
CASE
WHEN price IS NULL THEN 'Unpriced'
WHEN price < 10 THEN 'Bargain'
WHEN price BETWEEN 10 and 20 THEN 'Average'
ELSE 'Gift to impress relatives'
END
FROM titles
ORDER BY price
GO