SQL And, Or, Not
To combine multiple conditions, use AND, OR, and NOT keywords, and also brackets (, ) to set the priority.
For example, you want to select all songs' titles, that were produced between 1970 and 1990 years:
SELECT title FROM songs WHERE year >= 1970 AND year <= 1990
Or you can select all records where singer is not Pink Floyd:
SELECT * FROM songs WHERE NOT singer = 'Pink Floyd'
You can combine conditions for different columns, but not forget about brackets to define the priority:
SELECT * FROM songs WHERE NOT (singer = 'Pink Floyd' AND price = 100)
Compito
Swipe to start coding
Find all songs titles and prices of 20th century, where the price is less than 500, or where the singer is AC/DC.
Soluzione
Cambia al desktop per esercitarti nel mondo realeContinua da dove ti trovi utilizzando una delle opzioni seguentiTutto è chiaro?
Grazie per i tuoi commenti!
Sezione 1. Capitolo 7
Cambia al desktop per esercitarti nel mondo realeContinua da dove ti trovi utilizzando una delle opzioni seguenti