摘要:
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 ORD... 阅读全文
posted @ 2009-04-28 15:47 yuanws 阅读(160) 评论(0) 推荐(0) 编辑