FROM paamelding_kurs
WHERE karakter < 2.0;
FROM student;
FROM student s, paamelding_kurs pk
WHERE s.studentnr = pk.studentnr;
| SELECT | |
|
SELECT * FROM paamelding_kurs WHERE karakter < 2.0; |
| PROJECT | |
|
SELECT enavn, fnavn FROM student; |
| JOIN | |
| List ut alle studenter og deres karakterer i de enkelte fag |
SELECT studentnr, fnavn, enavn, kursnr, karakter FROM student s, paamelding_kurs pk WHERE s.studentnr = pk.studentnr; |