 ####   ##                   #                 ##   ##                   
######  ##                  ##                 ##   ##                   
##      #####  ####  ##### #### #####  ###     ##   ##                   
##      ## ##  # ##  ## ##  ##  ##  ## ##      ##   ##                  
##  ##  ## ## #####  ## ##  ##  ###### ##      ##   ##                   
######  ## ## ## ##  ## ##  ##  ## ### ##       ## ##   ##                 
 #####  ## ## #####  #####  ###  ####  ##        ###    ##               
                     ##                                                  
30.10.2001           ##                                                  

maximalny poplatok za izbu
SELECT max(poplatok)
FROM rn_typizby i;

studenti ktori platia maximalnu sumu
SELECT *
FROM rn_typizby i,rn_student s
WHERE s.idtypizby=i.id AND i.poplatok=500;

ale co ked chceme dynamicky select poplatku
SELECT *
FROM rn_typizby i,rn_student s
WHERE s.idtypizby=i.id AND 
i.poplatok=(SELECT max(poplatok) FROM rn_typizby i);
1 |A |2 |500.00 |1 |Jan |Hrasko |1980-01-01 |1 |1 |2 |M |220A |1 
1 |A |2 |500.00 |6 |Juraj |Trulo |1983-11-07 |4 |5 |3 |M |220A |1  

najstarsi student - meno, priezvisko, dat. nar
SELECT meno,priezvisko,datumnarod FROM rn_student
WHERE datumnarod=(SELECT min(datumnarod) FROM rn_student)
Ali |Baba |1970-12-11  

meno priezvisko odbor
SELECT st.meno, st.priezvisko, sk.nazov 
FROM rn_student st, rn_skupina sk
WHERE st.idskupina=sk.id 
Ali |Baba |Matematika 
Jan |Polienko |Matematika 
Jan |Hrasko |Matematicka informatika 
Juraj |Trulo |Matematicka informatika 
Ruzena |Sipova |Matematika-fyzika 
Juraj |Trulo |Matematika-fyzika  

zmenme vsetkym MF na MI
?????????
select odbor.kod, std.meno, std.priezvisko, std.datumnarod
from rn_student as s, rn_skupina as odbor
where std.idskupina = odbor.id

zmenme select aby vypisal vsetky odbory a studujucich na nich
select odbor.kod, std.meno, std.priezvisko, std.datumnarod 
from ml_student as std 
RIGHT OUTER JOIN ml_skupina AS odbor ON std.idskupina = odbor.id;

na ktorom odbore nie je ziaden student
SELECT sk.kod
FROM rn_skupina sk
WHERE sk.id in (SELECT DISTINCT st.idskupina FROM rn_student st)
M 
MI 
MF  

alebo:
SELECT sk.kod, sk.id
FROM rn_skupina sk
WHERE NOT EXISTS (SELECT * FROM rn_student st WHERE st.idskupina=sk.id)

vyselektujme studentov, usporiadajme podla datumu narodenia
SELECT st.meno, st.priezvisko 
FROM rn_student st
ORDER BY st.datumnarod DESC
Juraj |Trulo 
Juraj |Trulo 
Jan |Polienko 
Ruzena |Sipova 
Jan |Hrasko 
Ali |Baba  

ocislujme ich
(v kazdom kroku vieme spocitat mladsich..)
SELECT (SELECT COUNT(*) FROM rn_student s2 WHERE s1.datumnarod<=s2.datumnarod), s1.meno, s1.priezvisko
FROM rn_student s1
ORDER BY s1.datumnarod DESC
1 |Juraj |Trulo 
2 |Juraj |Trulo 
3 |Jan |Polienko 
4 |Ruzena |Sipova 
5 |Jan |Hrasko 
6 |Ali |Baba  

3 najstarsi ludia
SELECT s1.meno, s1.priezvisko
FROM rn_student s1
WHERE (SELECT COUNT(*) FROM rn_student s2 WHERE s1.datumnarod<=s2.datumnarod)<4
ORDER BY s1.datumnarod DESC
Juraj |Trulo 
Juraj |Trulo 
Jan |Polienko  

WITH
"prosim, pozrite si v helpe"