非等值连接,外连接,自连接,子查询

非等值连接:

select empno,ename,sal,grade from emp,salgrade where sal between salgrade.losal and salgrade.hisal;select empno,ename,sal,grade from emp,