Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SQL_IND_04
- -SQL_IND04_01
- select max(transakcii.iznos)
- from transakcii
- -SQL_IND04_02
- select transakcii.br_smetka,transakcii.br_transakcija
- from transakcii
- where iznos=(select max(transakcii.iznos)
- from transakcii)
- -SQL_IND04_03
- select banki.id_banka,banki.naziv_banka,s.br_smetka,t.br_transakcija,t.iznos
- from banki
- left outer join smetki as s
- on banki.id_banka=s.id_banka
- left outer join transakcii as t
- on s.br_smetka=t.br_smetka
- -SQL_IND04_04
- select b.id_banka,b.naziv_banka,max(t.iznos)
- from banki as b
- left join smetki as s
- on b.id_banka=s.id_banka
- left join transakcii as t
- on s.br_smetka=t.br_smetka
- group by b.id_banka
- -SQL_IND04_05
- select b.id_banka,b.naziv_banka,s.br_smetka,t.br_transakcija,t.iznos,v.ime_vraboten
- from banki b
- left join smetki as s
- on b.id_banka=s.id_banka
- left join transakcii as t
- on s.br_smetka=t.br_smetka
- left join odgovoren as odg
- on (t.br_smetka,t.br_transakcija)=(odg.br_smetka, odg.br_transakcija)
- left join vraboteni as v
- on (b.id_banka,odg.id_vraboten)=(v.id_banka, v.id_vraboten)
Add Comment
Please, Sign In to add comment