Advertisement
Guest User

Untitled

a guest
Oct 15th, 2019
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. --1
  2. select ename, dname
  3. from emp
  4. join dept
  5. on emp.deptno=dept.deptno order by dname
  6. --2
  7. select emp.deptno,ename, dname
  8. from emp
  9. join dept
  10. on emp.deptno=dept.deptno order by dname
  11. --3
  12. select ename, loc, dname
  13. from emp
  14. join dept
  15. on emp.deptno=dept.deptno
  16. where sal > 1500
  17. --4
  18. select ename, job, sal, grade
  19. from emp, salgrade
  20. where emp.sal between losal and hisal
  21. --5
  22. select ename, job, sal, grade
  23. from emp, salgrade
  24. where emp.sal between losal and hisal and salgrade.grade=3
  25. --6
  26. select ename, sal, loc
  27. from emp
  28. join dept
  29. on emp.deptno=dept.deptno
  30. where loc='DALLAS'
  31. --7
  32. select dept.deptno, ename
  33. from emp
  34. full outer join dept on emp emp.deptno=dept.deptno
  35. where empno is null
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement