distinct去重
select distinct job from emp;
select distinct job,deptno from emp;联合去重
select count(distinct job) from emp;
连接查询
两张表连接没有任何限制会发生笛卡尔积现象
select ename,dname from emp,dept;
加条件限制避免笛卡尔积现象,
sql92语法:
缺点:结构不清晰,表连接条件和后期筛选条件杂糅在where里面
select
e.ename,d.dname
from
emp e,dept d
where
e.deptno = d.deptno;