SELECT Ticket_Price,
CASE Ticket_Price > 60 THEN 'Golden Seat'
ELSE
(
CASE WHEN Ticket_Price > 30 THEN 'Bronze Seat'
ELSE 'Silver Seat'
END
)
END
AS "Ticket_Category"
FROM ROUTE;
我使用 oracle live sql 來顯示票價和一個名為“Ticket_Category”的新創建的列并動態為其分配值，但我一直收到此錯誤
uj5u.com熱心網友回復：
您需要將查詢更新為 -
SELECT Ticket_Price,
CASE WHEN Ticket_Price > 60 THEN 'Golden Seat'
ELSE
CASE WHEN Ticket_Price > 30
THEN 'Bronze Seat'
ELSE 'Silver Seat'
END
END AS "Ticket_Category"
FROM ROUTE;
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/325097.html
上一篇：從Select陳述句創建一個新列，然后在一個程序中將其與另一個Select陳述句組合以回傳一個資料表
下一篇：Oraclesql-匯總折扣