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:
12SELECT title FROM songs WHERE year >= 1970 AND year <= 1990
Or you can select all records where singer is not Pink Floyd:
12SELECT * FROM songs WHERE NOT singer = 'Pink Floyd'
You can combine conditions for different columns, but not forget about brackets to define the priority:
12SELECT * FROM songs WHERE NOT (singer = 'Pink Floyd' AND price = 100)
Swipe to start coding
Find all songs title
s and price
s of 20th century, where the price
is less than 500, or where the singer
is AC/DC.
Solução
Obrigado pelo seu feedback!
single
Pergunte à IA
Pergunte à IA
Pergunte o que quiser ou experimente uma das perguntas sugeridas para iniciar nosso bate-papo
Resumir este capítulo
Explicar o código em file
Explicar por que file não resolve a tarefa
Awesome!
Completion rate improved to 4.17
SQL And, Or, Not
Deslize para mostrar o menu
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:
12SELECT title FROM songs WHERE year >= 1970 AND year <= 1990
Or you can select all records where singer is not Pink Floyd:
12SELECT * FROM songs WHERE NOT singer = 'Pink Floyd'
You can combine conditions for different columns, but not forget about brackets to define the priority:
12SELECT * FROM songs WHERE NOT (singer = 'Pink Floyd' AND price = 100)
Swipe to start coding
Find all songs title
s and price
s of 20th century, where the price
is less than 500, or where the singer
is AC/DC.
Solução
Obrigado pelo seu feedback!
Awesome!
Completion rate improved to 4.17single