我有这个表的表结构prices
:
CREATE TABLE prices
(
id int,
priceFrom int,
priceUp int
);
INSERT INTO prices (id, priceFrom, priceUp)
VALUES (1, 23, 23), (2, 0, 0), (3, 12, 13),
(4, 40, 40), (5, 15, 15), (6, 0, 0);
这是结果:
我有这样的疑问:
select
pricefrom, priceup,
case
when pricefrom = 0 then null
when priceFrom <> priceUp then priceFrom + ' - ' + priceUp
when priceFrom = priceUp then priceFrom
end as FinalPrice
from
prices
我需要做的是
- Pricefrom = 0 然后显示 null
- Pricefrom = Priceup 然后显示价格
- 至少如果pricefrom!=priceup我想显示例如:12(pricefrom) - 13(priceup)
但在我的这一行查询中:
我尝试这样做<>
但结果中显示两个数字的总和:
我怎样才能解决这个问题?