Advertisement
Guest User

Untitled

a guest
Jan 22nd, 2019
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. 1)SELECT DATEDIFF('2019-01-21','2000-02-14')
  2. 2)SELECT oddzial FROM pracownicy WHERE date(data_zatrudnienia)<NOW()
  3. 3)SELECT YEAR(data_zatrudnienia)-2019 FROM pracownicy WHERE date(data_zatrudnienia)
  4. 4)SELECT CONCAT_WS("", imie, nazwisko) AS Dane
  5. FROM pracownicy
  6. 5)SELECT SUBSTR(imie, 1, 1) AS Imię, SUBSTR(nazwisko,1,1) AS Naziwsko FROM pracownicy;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement