Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --zad5
- SELECT INITCAP(o.nazwisko)||' '||INITCAP(o.imie1) osoba, INITCAP(w.nazwa) nazwa, TO_CHAR(z.od, 'DD/MM/YYYY') od, z.pensja||' zl' pensja
- FROM Osoby o JOIN Zatrudnienia z ON o.id_os = z.id_os JOIN Wydzialy w ON z.id_w = w.id_w
- WHERE z.do IS NULL;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement