Q. Does the following MySQL statement belong to the "Inequality condition"?
SELECT product_type.name, product.name
FROM product_type INNER JOIN Product
ON product_type.dept=Product.dept
WHERE product_type.name! =’customers_accounts’;
SELECT product_type.name, product.name
FROM product_type INNER JOIN Product
ON product_type.dept=Product.dept
WHERE product_type.name! =’customers_accounts’;
β
Correct Answer: (A)
Yes
Explanation: This question asks if the given MySQL statement uses an inequality condition.