Question

Which of the following SQL query will filter products having cost more than 500?

• A. SELECT ProductName FROM PRODUCTS WHERE Cost$>$500;
• B. SELECT ProductName FROM PRODUCTS GROUP BY Cost$>$500;
• C. SELECT ProductName FROM PRODUCTS HAVING Cost$>$500;
• D. SELECT DISTINCT ProductName FROM PRODUCTS HAVING Cost$>$500;

Hint:

Always use WHERE for conditions on individual records.
Always use HAVING for conditions on aggregated groups!
WHERE comes before GROUP BY, while HAVING comes after GROUP BY!

Answer 1

The Correct Option is A

Step 1: Understanding the Concept:
The ‘WHERE‘ clause is the standard method for filtering individual records in an SQL table based on specific conditions before any grouping occurs.

Step 2: Detailed Explanation:
1. ‘WHERE‘ filters rows based on a condition (Cost > 500).
2. ‘HAVING‘ is used specifically for filtering *aggregated* data (after a ‘GROUP BY‘ clause).
3. ‘GROUP BY‘ is used for aggregating data, not filtering rows.

Step 3: Final Answer:
The correct query is (A).