SQL Select 1

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'