重庆思庄Oracle、Redhat认证学习论坛

标题: [分享]047课后第三题 [打印本页]

作者: 5dm    时间: 2012-10-21 14:57
标题: [分享]047课后第三题
 
3. The HR department needs to find high-salary and low-salary employees. Modify lab_02_01.sql to display the last name and salary for any employee whose salary is not in the $5,000–$12,000 range. Place your SQL statement in a text file named lab_02_03.sql.

 

 

这个题除了用大于多少小于多少的条件外,还可以这么写:

select last_name,salary from employees where salary not between 5000 and 12000;






欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2