Question

Q.
write a query to display names and price of all the products which is not manufacturer "Avon Fitness".

plz ans
no span ans please​

Answer 1

Command:

Select names, price from Product where manufacturer!="Avon_Fitness";

Explanation:

• Select chooses whoch columns to display
• manufacturer!="Avon_Fitness"; makes sure the manufacturer value isn't equal to "Avon_Fitness".

PS Make sure there is no space between letters in names it will cause error instead use underscore.