SHARE
TWEET

Untitled

a guest Jan 27th, 2020 86 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. EMP.DEPTNO=DEPT.DEPTNO AND SAL IN(SELECT MAX(SAL)
  2. FROM EMP
  3. GROUP BY DEPTNO); ---
  4. WHERE SAL >=(SELECT AVG(SAL)
  5. FROM EMP); ----
  6. WHERE EMP.DEPTNO=DEPT.DEPTNO AND EMP.SAL=1500; -----
  7. SELECT ENAME + ' pracuje na stanowisku ' + JOB + ' w zespole ' + DEPTNO + 'od')
  8. FROM EMP; ------
  9. WHERE DEPTNO NOT IN(SELECT DEPTNO FROM EMP)
  10. ORDER BY DEPTNO; ------
  11. N.imie J.przedmiot
  12. FROM Uczniowie_dane AS N, Uczniowie_oceny AS J; -----
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top