Multiple choice

Consider the following table:

Product Table:

|Category|Product_Name|Product_Price|State|Country| |---|---|---|---|---| |Furniture|Chair|700 Rs|Colordo|US| |Furniture|Bed|2000 Rs|Colordo|US| |Electronics|TV|1200 Rs|Capetown|Africa| |Electronics|Radio|700 Rs|Delhi|India| |Leather|Bag|800 Rs|Mumbai|India| |Garments|Jacket|2300 Rs|Nairobi|Kenya|

WAQ to find the details of products whose price is not equal to 2000.

  1. SELECT * FROM product WHERE NOT product_price=2000

  2. SELECT * FROM product WHERE product_price!=2000

  3. SELECT * FROM product WHERE EXCEPT product_price=2000

  4. Both (1) and (2)

  5. (1), (2) and (3) all are true
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Yes, both are the correct queries to fetch specified records.

Keep practicing — related questions