Oracle学习笔记之单表查询

Oracle学习笔记

单表查询

---

---

oracle单表查询

1.DISTINCT

--数据去重 DISTINCT
--求员工的年龄段
SELECT DISTINCT EAGE FROM EMP;

2.投影查询

2.1 并集

--投影查询  前提 查询的结果集列数相同而且数据类型兼容
--union  查询结果会去重
--union all 查询结果不去重
SELECT * FROM EMP WHERE EAGE>22
UNION ALL
SELECT * FROM EMP WHERE ENAME='xx';

2.2 交集

SELECT * FROM EMP WHERE EAGE>22
INTERSECT
SELECT * FROM EMP WHERE ENAME='xx';

2.3 差集

SELECT * FROM EMP WHERE EAGE>22
MINUS
SELECT * FROM EMP WHERE ENAME='xx';

3.算数运算符

--求员工的年薪   薪资*12+奖金*0.5-4000W
SELECT SAL*12