Oracle学习总结6--集合查询、排序

集合查询

--查询从事CLERK或者是MANAGER工作的员工信息
select * from emp where job='CLERK' or job='MANAGER'

--通过集合查询进行查找
select * from emp where job in ('CLERK','MANAGER')
--查询所有在1980和1982年入职的员工信息
select * from emp where to_char(hiredate,'yyyy')  in  ('1980','1982')

--查询所有不在1980和1982年入职的员工信息
select * from emp where to_char(hiredate,'yyyy') not in ('1980','1982')

--查询从事CLERK或者是MANAGER工作的员工信息
select * from emp where job='CLERK' or job='MANAGER'
--查询不从事 CLERK和MANAGER工作的员工信息
select * from emp where job != 'CLERK' and job <> 'MANAGER' 
select * from emp where job not in ('CLERK','MANAGER')


--通过集合查询进行查找
select * from emp where job in ('CLERK','MANAGER')
--查询所有在1980和1982年入职的员工信息
select * from emp where to_char(hiredate,'yyyy')  in  ('1980','1982')

--查询所有不在1980和1982年入职的员工信息
select * from emp where to_char(hiredate,'yyyy') not in ('1980','1982')

排序

--查询工资大于1600的员工信息
select * from e