Зміст курсу
SQL Tutorial for Beginners
SQL Tutorial for Beginners
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)
Завдання
Find all songs titles and prices of 20th century, where the price is less than 500, or where the singer is AC/DC.
Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантівДякуємо за ваш відгук!
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)
Завдання
Find all songs titles and prices of 20th century, where the price is less than 500, or where the singer is AC/DC.
Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантівДякуємо за ваш відгук!
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)
Завдання
Find all songs titles and prices of 20th century, where the price is less than 500, or where the singer is AC/DC.
Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантівДякуємо за ваш відгук!
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)
Завдання
Find all songs titles and prices of 20th century, where the price is less than 500, or where the singer is AC/DC.
Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантівПерейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів