Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --CUBE
- SELECT id_miesiac, id_produkt, SUM(koszt) AS suma_sprzedazy
- FROM sprzedaz
- GROUP BY cube (id_miesiac , id_produkt);
- --ROLLUP
- SELECT id_kurort , id_produkt, id_miesiac, SUM(ilosc) AS sprzedaz_towarow_w_miesiacu
- FROM sprzedaz
- GROUP BY rollup (id_kurort, id_produkt, id_miesiac);
- --GROUPING SETS
- SELECT id_kurort, id_produkt, SUM(koszt) AS suma_sprzedazy
- FROM sprzedaz
- GROUP BY GROUPING sets ((id_produkt, id_kurort), (id_kurort) );
- --PARTITION
- Nie bardzo wiem o co tam chodzi
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement