摘要: SELECTname, salary,CASEWHEN salary = 50000.0 AND salary = 70000.0 AND salary < 100000.0 THEN 'high'ELSE 'very high'END AS bracketFROM employees; 阅读全文
posted @ 2013-10-12 10:10 沙漠里的小鱼 阅读(440) 评论(0) 推荐(0) 编辑