1、 查询员工的工资大于1000的员工姓名、员工工作、员工工资
select ename,job,sal from emp where sal>1000;
-- > < >= <= = !=
select ename,job,sal from emp where sal!=1000;
2、查询员工的姓名叫'smith'的员工的工资是多少?
select sal,ename from emp where ename='smith';
3、查询没有奖金的员工的姓名和工资以及奖金
select ename,sal,comm from emp where comm is not null;
4、查询员工的工资在1200-4000之间的员工的姓名和工资
select ename,sal from emp where 1200<=sal and sal<=4000;
5、查询 员工编号为 7369 7788 7881的员工信息
select * from emp where empno not