Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- pobieranie daty z serwera
- select cast('today' as date) from osoby;
- pobranie daty i czasu (systemowe)
- select cast('now' as timestamp) from RDB$DATABASE;
- wyswietlenie samego roku
- select extract(year from cast('today' as date)) from RDB$DATABASE;
- wyswietlenie imienia nazwiska i rok urodzenia osoby
- select imie, nazwisko, extract(year from data_urodzenia) from osoby;
- wyswietylnie imienia nazwsika ilość lat osoby
- select imie, nazwisko, extract(year from cast('today' as date)) - extract(year from data_urodzenia) from osoby;
- DODATNIE KOLUMNY Z 'STARY', MLODY , OK
- select imie, nazwisko, extract(year from cast('today' as date)) - extract(year from data_urodzenia),
- CASE
- WHEN extract(year from cast('today' as date)) - extract(year from data_urodzenia) < 18 THEN 'MLODY'
- WHEN extract(year from cast('today' as date)) - extract(year from data_urodzenia) > 18 THEN 'STARY'
- WHEN extract(year from cast('today' as date)) - extract(year from data_urodzenia) = 18 THEN 'OK'
- ELSE ' '
- END AS "WIEK"
- from osoby
- TO SAMO TYLKO Z PARAMETREM
- select imie, nazwisko, extract(year from cast('today' as date)) - extract(year from data_urodzenia),
- CASE
- WHEN extract(year from cast('today' as date)) - extract(year from data_urodzenia) < :LATA THEN 'MLODY'
- WHEN extract(year from cast('today' as date)) - extract(year from data_urodzenia) > :LATA THEN 'STARY'
- WHEN extract(year from cast('today' as date)) - extract(year from data_urodzenia) = :LATA THEN 'OK'
- ELSE ' '
- END AS "WIEK"
- from osoby
- DODANIE PROCEDURY
- begin
- SUMA = :SKLADNIK1 + :SKLADNIK2;
- SUSPEND;
- end
- WYWOŁANIE PROCEDURY DZIALANIA
- select SUMA
- from DZIALANIA(2,2)
- WYKORZYSTANIE PROCEDURY DO DODANIE DO NUMERY LICZBY 2
- select O.NAZWISKO, O.NUMER,
- S.SUMA from OSOBY AS O
- LEFT JOIN DZIALANIA(O.NUMER,2) AS S ON 1=1;
- TWORZENIE WIDOKU
- /* View: WIDOK1, Owner: SYSDBA */
- CREATE VIEW "WIDOK1" (
- "IMIE",
- "NAZWSIKO",
- "MIASTO"
- ) AS
- SELECT O.IMIE, O.NAZWISKO, M.MIASTO FROM OSOBY AS O
- LEFT JOIN MIASTA AS M ON O.ID_OSOBY = M.ID_MIASTA
- ;
- //WYWOLANIE WIDOKU
- SELECT * FROM WIDOK1;
- ////////////////////
- WYSWIETLENIE IMIENIA NAZWISKA I SUMY HARACZU DLA OSOB (10000)
- SELECT O.IMIE, O.NAZWISKO, SUM(H.KWOTA)
- FROM OSOBY AS O
- LEFT OUTER JOIN HARACZE AS H ON O.ID_OSOBY = H.ID_OSOBY
- GROUP BY 1,2
- //NADAWANIE UPRAWNIEN UZYTKOWNIKA
- //BACKUP BAZY DANYCH
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement