面试题sql

查询书的价格10到20 之前显示10to20 没有显示unknown

 

CREATE TABLE book(
price INT,
NAME VARCHAR(20)
)

SELECT NAME AS '名字',price,(CASE WHEN price>=10 AND price<=20 THEN '10 to 20' ELSE 'unknow' END)AS '结果'

FROM book

 

posted @ 2017-11-01 00:22  _HelloWord  阅读(134)  评论(0)    收藏  举报