1.查找工种为clerk员工的信息
select * from emp where job=‘CLERK’;
2.查找1980-12-17入职的员工信息
select * from emp where hiredate=‘17-12月-1980’;
3.查找奖金为空值的员工信息(comm)
select * from emp where comm is null;
4.查找职工编号为7902/7566/7788员工信息
select * from emp where empno in(7902,7566,7788);
5.查找ENAME以S开头的员工信息
select * from emp where ename like ‘S%’;
6.查找sal大于等于1100并且job为‘CLERK’
select * from emp where sal>=1100 and job=‘CLERK’;
7.工种不为clerk、manager、analyst的员工姓名和工种
select ename,job from emp where job not in(‘CLERK’,‘MANAGER’,‘ANALYST’);
8.根据部门编号的降序来查看我们员工的信息
select * from emp order by deptno desc;
9.查看员工的月总收入,并按月总收入的降序排列输出结果
select ename,sal+comm as salary from emp order by salary desc;
10.根据部门编号的降序和收入的升序来查看我们员工信息
select * from emp order by deptno desc ,sal;
Oracle限定查询和排序
最新推荐文章于 2022-08-29 16:14:35 发布