SHARE
TWEET

Untitled

a guest Jan 20th, 2020 53 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT nazwisko, TO_CHAR(zatrudniony, 'Month, dd yyyy') AS DATA_ZATRUDNIENIA FROM pracownicy WHERE id_zesp = 20;
  2. SELECT TO_CHAR(CURRENT_DATE, 'fmDAY')AS DZIS FROM pracownicy WHERE id_prac = 100;
  3. SELECT nazwa, adres, CASE adres
  4.     WHEN 'PIOTROWO 3A' THEN 'NOWE MIASTO'
  5.     WHEN 'STRZELECKA 14' THEN 'STARE MIASTO'
  6.     WHEN 'WLODKOWICA 16' THEN 'GRUNWALD'
  7.     WHEN 'MIELZYNSKIEGO 30' THEN 'STARE MIASTO'
  8.     END AS dzielnica FROM zespoly;
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