Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT nazwisko, TO_CHAR(zatrudniony, 'Month, dd yyyy') AS DATA_ZATRUDNIENIA FROM pracownicy WHERE id_zesp = 20;
- SELECT TO_CHAR(CURRENT_DATE, 'fmDAY')AS DZIS FROM pracownicy WHERE id_prac = 100;
- SELECT nazwa, adres, CASE adres
- WHEN 'PIOTROWO 3A' THEN 'NOWE MIASTO'
- WHEN 'STRZELECKA 14' THEN 'STARE MIASTO'
- WHEN 'WLODKOWICA 16' THEN 'GRUNWALD'
- WHEN 'MIELZYNSKIEGO 30' THEN 'STARE MIASTO'
- END AS dzielnica FROM zespoly;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement