Uke 1: Hva har jeg lært hittil?

    SELECT * FROM tabell;

    SELECT felt1, felt2, ..., feltn 
    FROM tabell;

    SELECT DISTINCT felt
    FROM tabell;

    SELECT felt1, felt2, ..., feltn 
    FROM tabell
    WHERE betingelse 
    AND/OR annen_betingelse;

    betingelse/annen_betingelse kan være for eksempel:
    post = verdi
    post <> verdi
    post > verdi
    post < verdi
    post BETWEEN verdi1 AND verdi2
    post LIKE verdi
    post NOT LIKE verdi
    post IS NULL
    post IS NOT NULL

    SELECT felt1, felt2, ..., feltn 
    FROM tabell
    WHERE betingelse
    ORDER BY felt1, felt2, ..., feltn DESC;

    SELECT felt1, felt2, ..., feltn 
    FROM tabell
    WHERE betingelse
    ORDER BY felt1, felt2, ..., feltn ASC;

    SELECT felt1, felt2, ..., feltn    (evt. tabellnavn.feltnavn hvis tabell1 og tabell2 har noen like felter)
    FROM tabell1, tabell2
    WHERE tabell1.PK = tabell2.FK;

    SELECT felt1, felt2, ..., feltn 
    FROM tabell
    WHERE felt IN(
      SUBQUERY eller verdiliste);

    SUBQUERY er en ny SQL-spørring
    verdiliste kan for eksempel være (0, 1, 2) eller ('a', 'b', 'c')

    SELECT felt1, felt2, ..., feltn 
    FROM tabell
    WHERE felt NOT IN(
      SUBQUERY eller verdiliste);

    SELECT felt1, felt2, ..., feltn 
    FROM tabell
    WHERE felt EXISTS(
      SUBQUERY);