VIP会员
购物车
私信
发表新帖
立即签到
关注
回复
支持(
反对(
首页上一页 1 下一页尾页 1 条记录 1/1页
《sql server 入门经典》 p89页实例4.14的问题
发表在Oracle视频答疑
2015-01-19
是否精华
是
否
版块置顶:
是
否
实例代码如下：
USE pubs
SELECT 'Price Kind' =
CASE
WHEN price IS NULL THEN 'Not yet priced'
WHEN price < 20 THEN 'Very Reasonable Title'
[font color=#FF0000]WHEN price >= 20 and price < 20 THEN 'Coffee Table Title'
[/font] ELSE 'Expensive book!'
END,
CAST(title AS varchar(20)) AS 'Shortened Title'
FROM titles
ORDER BY price
请问标红这句想表达什么意思，在实务中有什么意义
USE pubs
SELECT 'Price Kind' =
CASE
WHEN price IS NULL THEN 'Not yet priced'
WHEN price < 20 THEN 'Very Reasonable Title'
[font color=#FF0000]WHEN price >= 20 and price < 20 THEN 'Coffee Table Title'
[/font] ELSE 'Expensive book!'
END,
CAST(title AS varchar(20)) AS 'Shortened Title'
FROM titles
ORDER BY price
请问标红这句想表达什么意思，在实务中有什么意义
分享到：
