Podatkovne baze 1

« nazaj

Podatkovne baze 1 - vaje 2.11.2020

SELECT stolpci
FROM tabela1 [LEFT | RIGHT | FULL] JOIN tabela2
  ON pogoj AND tabela1.st1 = tabela2.st2
  JOIN tabela3 USING (st1, st2, st3)
  NATURAL JOIN tabela4
WHERE pogoj
GROUP BY stolpci
HAVING pogoj
ORDER BY stolpci
LIMIT stevilo

---

The JOIN operation

Naloga	DA	DB	MČ	AG	HKK	LM	MO	SO	MP	TP	PR	TS	LŠ	AT
1	x	X	x	X	x	X	X	X	X	X	X	X	X	X
2	x	X	x	X	x	X	X	X	X	X	X	X	X	X
3	x	X	x	X	x	X	X	X	X	X	X	X	X	X
4	x	X	x	X	x	X	X	X	X	X	X	X	X	X
5	x	X	x	X	x	X	X	X	X	X	X	X	X	X
6	x	X	x	X	x	X	X	X	X	X	X	X	X	X
7	x	X	x	X	x	X	X	X	X	X	X	X	X	X
8	x	X	x	X	x	X	X	X	X	X	X	X	X	X
9	x	X	x	X	x	X	X	X	X	X	X	X	X	X
10	x	X	x	X	x	X	X	X	X	X	X	X	X	X
11	x	X	x	X	x	X	X	X	X	X	X	X	X	X
12	x	X	x	X	x	X	X	X	X	X	X	X	X	X
13				X		X		/	/		/	/		/

---

More JOIN operations

Naloga	DA	DB	MČ	AG	HKK	LM	MO	SO	MP	TP	PR	TS	LŠ	AT
1	x	X	x	X	x	X	X	X	X	X	X	X	X	X
2	x	X	x	X	x	X	X	X	X	X	X	X	X	X
3	x	X	x	X	x	X	X	X	X	X	X	X	X	X
4	x	X	x	X	x	X	X	X	X	X	X	X	X	X
5	x	X	x	X	x	X	X	X	X	X	X	X	X	X
6	x	X	x	X	x	X	X	X	X	X	X	X	X	X
7	x	X	x	X	x	X	X	X	X	X	X	X	X	X
8	x	X	x	X	x	X	X	X	X	X	X	X	X	X
9		X	x	X	x	X	X	X	X	X	X	X	X	X
10	x	X	x	X	x	X	X	X	X	X	X	X	X	X	X
11	x	X	x	X	x	X	X	X	X	X	X	X	X	X
12				X	x	X	X	X	X		X	X	X	X
13				X		X		X	X		X	X	X	X
14				X		X		X	X		X	X	X	X
15				X		X		X	X			X	X	X

Ta stran je odprtokodna. Izboljšaj to stran.

Ta zapisek je dostopen tudi na HackMD.