Q. You need to select all records from a ‘Products’ table where the price is exactly 19.99. What is the correct WHERE clause?

A
WHERE price = 19.99
B
WHERE price is 19.99
C
WHERE price == 19.99
D
WHERE price matches 19.99
Solution:

The = operator is used for equality checks in a WHERE clause for numeric and text values.

Entri Contact Image

Get Expert Advice for Free: Register for Your Free Consultation Now!