Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --1
- select ename, dname
- from emp
- join dept
- on emp.deptno=dept.deptno order by dname
- --2
- select emp.deptno,ename, dname
- from emp
- join dept
- on emp.deptno=dept.deptno order by dname
- --3
- select ename, loc, dname
- from emp
- join dept
- on emp.deptno=dept.deptno
- where sal > 1500
- --4
- select ename, job, sal, grade
- from emp, salgrade
- where emp.sal between losal and hisal
- --5
- select ename, job, sal, grade
- from emp, salgrade
- where emp.sal between losal and hisal and salgrade.grade=3
- --6
- select ename, sal, loc
- from emp
- join dept
- on emp.deptno=dept.deptno
- where loc='DALLAS'
- --7
- select dept.deptno, ename
- from emp
- full outer join dept on emp emp.deptno=dept.deptno
- where empno is null
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement