Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM pobocky ORDER BY NAZEV ASC;
- SELECT Pracovnici.Jmeno, Pracovnici.Prijmeni FROM PRACOVNICI ORDER BY Prijmeni ASC;
- SELECT nazev FROM zbozi WHERE nazev LIKE 'S%';
- SELECT * FROM Prodeje JOIN Zbozi USING(ID_ZBOZI)
- WHERE datum_prodeje BETWEEN TO_DATE('01.02.2015','dd.mm.yyyy')
- AND TO_DATE('15.02.2015','dd.mm.yyyy') AND NAZEV LIKE 'Fanta';
- SELECT * FROM zbozi WHERE nazev LIKE 'Fanta';
- SELECT nazev FROM pobocky WHERE KOD_ZEME = 'USA' ORDER BY nazev ASC;
- CREATE OR REPLACE VIEW cv6_v_prodejny_usa AS SELECT nazev FROM pobocky WHERE KOD_ZEME = 'USA' ORDER BY nazev ASC ;
- SELECT * FROM cv6_v_prodejny_usa;
- SELECT KATEGORIE FROM zbozi JOIN KURZY USING(platnost_od) WHERE KOD_MENY LIKE 'CZK';
- SELECT KATEGORIE
- FROM zbozi
- JOIN kurzy
- ON kurzy.platnost_od = '1.1.2015'
- JOIN prodeje
- ON prodeje.DATUM_PRODEJE = '1.1.2015';
- CREATE OR REPLACE VIEW cv6_v_kategorie_czk_1d(nazev) AS SELECT KATEGORIE
- FROM zbozi
- JOIN kurzy
- ON kurzy.platnost_od = '1.1.2015'
- JOIN prodeje
- ON prodeje.DATUM_PRODEJE = '1.1.2015';
- SELECT * FROM cv6_v_kategorie_czk_1d;
- CREATE OR REPLACE VIEW cv6_v_prod_neobjednano(nazev, adresa, telefon) AS
- SELECT nazev, adresa, telefon FROM pobocky
- JOIN pracovnici ON pracovnici.ID_POBOCKY = pobocky.ID_POBOCKY
- WHERE jmeno IS NULL ORDER BY nazev ASC;
- SELECT * FROM cv6_v_prod_neobjednano;
- CREATE OR REPLACE VIEW cv6_v_zbozi_pro_CZ_15182(nazev, cena, mnozstvi) AS
- SELECT zbozi.nazev, zbozi.cena, prodeje.mnozstvi
- FROM zbozi,prodeje
- WHERE zbozi.KOD_MENY = 'CZK' AND
- prodeje.kod_meny = 'CZK' AND
- datum_prodeje BETWEEN TO_DATE('15.02.2015','dd.mm.yyyy')
- AND TO_DATE('18.02.2015','dd.mm.yyyy');
- SELECT * FROM cv6_v_zbozi_pro_CZ_15182;
- SELECT nazev FROM zbozi WHERE nazev LIKE '%an%';
- Zobrazte název zboží, počet a cenu přepočtenou na EUR v kurzu platném od 1.2.2015 pro zboží, které se nachází v základní jednotce CZK.
- CREATE OR REPLACE VIEW cv6_v_zbozi_czk_na_eur(nazev, pocet, cena_eur) AS
- SELECT zbozi.nazev,prodeje.mnozstvi, zbozi.cena/(kurzy.kurz) AS "cena v eurech"
- FROM zbozi, prodeje, kurzy
- WHERE zbozi.KOD_MENY = 'CZK' AND
- prodeje.datum_kurzu = ('01.02.2015')
- AND prodeje.kod_meny = 'CZK'
- AND kurzy.kod_meny_z = 'CZK'
- AND kurzy.kod_meny_do = 'EUR';
- SELECT* FROM cv6_v_zbozi_czk_na_eur;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement