Question

What operators can be used in the WHERE clause in SQL

Answer 1

= 	Equal
<> 	Not equal
> 	Greater than
< 	Less than
>= 	Greater than or equal
<= 	Less than or equal
LIKE / NOT LIKE Pattern with wildcard characters
IN ( ...) List of values
AND / OR for conditions

 

70+ SQL courses for beginners and professionals

Answer 2

SELECT first_name, last_name, phone
FROM workers
WHERE last_name = 'Austin'

 

70+ SQL courses for beginners and professionals

Answer 3

SELECT first_name, last_name, phone
FROM workers
WHERE last_name <> 'Austin'

 

70+ SQL courses for beginners and professionals

Answer 4

SELECT course_name, cost
FROM courses
WHERE cost >= 1000

 

70+ SQL courses for beginners and professionals

Answer 5

SELECT course_name, cost
FROM courses
WHERE cost <= 1000

 

70+ SQL courses for beginners and professionals

Answer 6

SELECT course_name, cost
FROM courses
WHERE cost > 2000

 

70+ SQL courses for beginners and professionals

Answer 7

SELECT course_name, cost
FROM courses
WHERE cost < 500

 

70+ SQL courses for beginners and professionals

Answer 8

SELECT course_name, cost
FROM courses
WHERE cost BETWEEN 300 AND 500

 

70+ SQL courses for beginners and professionals

Answer 9

SELECT course_name, cost
FROM courses
WHERE cost IN (1000, 1100, 1200)

 

70+ SQL courses for beginners and professionals

Answer 10

SELECT first_name, last_name, phone
FROM workers
WHERE last_name LIKE 'A%'

 

70+ SQL courses for beginners and professionals

Answer 11

SELECT first_name, last_name, phone
FROM workers
WHERE last_name NOT LIKE 'A%'

 

70+ SQL courses for beginners and professionals

Answer 12

SELECT name, cost, city_code
FROM courses
WHERE cost = 750 AND (city_code = 3 OR city_code = 7)

 

70+ SQL courses for beginners and professionals