WorksheetsSQL Select 1
Total questions: 10
Worksheet time: 7mins
How to select all data from the table my_table_name?
SELECT * FROM my_table_name
SELECT ALL FROM my_table_name
SELECT ANY FROM my_table_name
SELECT ALL ROWS FROM my_table_name
How to select only rows which are equal by the condition?
SELECT * FROM my_table_name WHERE city = 'Berlin'
SELECT * FROM my_table_name WHERE city LIKE 'Berlin'
SELECT * FROM my_table_name WHERE city EQUAL 'Berlin'
SELECT * FROM my_table_name WHERE city EQUALS TO 'Berlin'
How to select only rows which aren't equal by the condition?
SELECT * FROM my_table_name WHERE city <> 'Berlin'
SELECT * FROM my_table_name WHERE city NOT LIKE 'Berlin'
SELECT * FROM my_table_name WHERE city NOT EQUAL 'Berlin'
SELECT * FROM my_table_name WHERE city NOT IN ('Berlin')
How to select only specific columns from the table?
SELECT city, country FROM customers
SELECT customers.city, customers.country FROM customers
SELECT c.city, c.country FROM customers c
SELECT COLUMNS city, country FROM customers
How to select values by many conditions? (choose all possible options)
SELECT * FROM Products WHERE price = 18 OR price = 19
SELECT * FROM Products WHERE price = 18 BETWEEN name LIKE 'nik'
SELECT * FROM Products WHERE price = 18 AND name LIKE 'nik'
SELECT * FROM Products WHERE price = 18 IN name LIKE 'nik'
Which of the proposed statements can return a result that is less or more than the given value?
SELECT * FROM Products WHERE price < 18
SELECT * FROM Products WHERE price LESS THEN 18
SELECT * FROM Products WHERE price BY 18
SELECT * FROM Products WHERE price BETWEEN 18 AND 100
How to select only NULL values?
SELECT * FROM Products WHERE price = NULL
SELECT * FROM Products WHERE price LIKE NULL
SELECT * FROM Products WHERE price IS NULL
SELECT * FROM Products WHERE price EQUALS NULL
How to select values by the last and first symbols in the char field?
SELECT * FROM Customers WHERE city LIKE 'B%'
SELECT * FROM Customers WHERE city LIKE 'B%n'
SELECT * FROM Customers WHERE city LIKE '%n'
SELECT * FROM Customers WHERE city LIKE 'B_%n'
How to select values from the specific range?
SELECT * FROM Products WHERE price IN (18, 22)
SELECT * FROM Products WHERE price BETWEEN 18
AND 22
SELECT * FROM Products WHERE price >= 18 AND
price <= 22
SELECT * FROM Products WHERE price >= 18 OR
price <= 22
How to select values which are included in the set (array)?
SELECT * FROM Products WHERE name LIKE ('nik', 'alex')
SELECT * FROM Products WHERE name IN ('nik', 'alex')
SELECT * FROM Products WHERE name LIKE 'nik'
OR name LIKE 'alex'
SELECT * FROM Products WHERE name BETWEE 'nik'
AND 'alex'
