Advertisement
Guest User

Untitled

a guest
Dec 10th, 2019
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. select o.* from osoby o, zatrudnienia z, wydzialy w where o.id=z.id_osoby and z.id_wydzialy=w.id and w.nazwa in
  2. (
  3. select w.nazwa from wydzialy w, zatrudnienia z where z.id_wydzialy=w.id and w.szef=
  4. (
  5. select w.szef from wydzialy w, osoby o ,zatrudnienia z where o.id=z.id_osoby and z.id_wydzialy=w.id and o.data_ur =
  6. (
  7. select min(o.data_ur) from osoby o,wydzialy w where o.id=w.szef
  8. )
  9. )
  10. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement