SQL für Fortgeschrittene
Jasmin Ludolf
Data Science Content Developer, DataCamp
WHERE
FilterklauselWHERE color = 'green'
SELECT title
FROM films
WHERE release_year > 1960;
|title |
|---------------------|
|Judgment at Nuremberg|
|Pocketful of Miracles|
|The Hustler |
|The Misfits |
...
SELECT title
FROM films
WHERE release_year < 1960;
|title |
|-----------------------------------------------|
|Intolerance:Love's Struggle Throughout the Ages|
|Over the Hill to the Poorhouse |
|The Big Parade |
|Metropolis |
...
SELECT title
FROM films
WHERE release_year <= 1960;
|title |
|-----------------------------------------------|
|Intolerance:Love's Struggle Throughout the Ages|
|Over the Hill to the Poorhouse |
|The Big Parade |
|Metropolis |
...
SELECT title
FROM films
WHERE release_year = 1960;
|title |
|-------------|
|Elmer Gantry |
|Psycho |
|The Apartment|
SELECT title
FROM films
WHERE release_year <> 1960;
|title |
|-----------------------------------------------|
|Intolerance:Love's Struggle Throughout the Ages|
|Over the Hill to the Poorhouse |
|The Big Parade |
|Metropolis |
...
>
Größer als oder nach<
Weniger als oder vor=
gleich>=
größer als oder gleich<=
kleiner als oder gleich<>
ungleichSELECT title
FROM films
WHERE country = 'Japan';
|title |
|-----------------|
|Seven Samurai |
|Tora! Tora! Tora!|
|Akira |
|Madadayo |
|Street Fighter |
...
-- Written code:
SELECT item
FROM coats
WHERE color = 'green'
LIMIT 5;
FROM Ummantelungen
WHERE color = 'grün'
SELECT item
LIMIT 5;
SQL für Fortgeschrittene