我已经搜索了很长时间如何做到这一点,但是由于搜索时涉及的单词难以置信地难以找到接近我想要找出的东西!
如何在创建视图中使用sql CASE表达式?
谁能告诉我正确的语法?
下面是我现在的样子,但是它不能正常工作。
create view vw_price as
select vehicle.price
(case when price between 0 and 999 then ‘0-999’
when price between 1000 and 1999 then ‘1000-1999’
when price between 2000 and 2999 then ‘2000-2999’
when price between 3000 and 3999 then ‘3000-3999’
when price between 4000 and 4999 then ‘4000-4999’
when price between 5000 and 5999 then ‘5000-5999’
when price between 6000 and 6999 then ‘6000-6999’
when price between 7000 and 7999 then ‘7000-7999’
when price between 8000 and 8999 then ‘8000-8999’
when price between 9000 and 9999 then ‘9000-9999’
end) as price_group from vehicle;
下面的语法应该可以创建所需的视图。我想你只是在case语句前少了一个逗号。
USE [<<<database_name>>>]
GO
CREATE VIEW vw_price
AS
select price,
(case
when price between 0 and 999 then '0-999'
when price between 1000 and 1999 then '1000-1999'
when price between 2000 and 2999 then '2000-2999'
when price between 3000 and 3999 then '3000-3999'
when price between 4000 and 4999 then '4000-4999'
when price between 5000 and 5999 then '5000-5999'
when price between 6000 and 6999 then '6000-6999'
when price between 7000 and 7999 then '7000-7999'
when price between 8000 and 8999 then '8000-8999'
when price between 9000 and 9999 then '9000-9999'
end) "price_group" from vehicle;
GO