An easy way to solve match-the-following questions is to start with the most obvious clause.
ORDER BY is always used for sorting or ordering data, matching C to III.
This immediately helps eliminate incorrect choices.
• Step 1: Understanding the Question:
The question asks us to match different SQL clauses listed in List-I with their accurate functional descriptions provided in List-II.
A thorough understanding of basic SQL commands is required to make the correct associations.
• Step 2: Key Formula or Approach:
Let's analyze the purpose of each SQL clause:
- GROUP BY: Groups rows that share a common attribute value together into summary rows.
- HAVING: Applies conditional filters on these grouped summary rows.
- ORDER BY: Sorts the resulting records in ascending or descending order.
- WHERE: Filters individual records before any grouping is performed.
• Step 3: Detailed Explanation:
Let's match each clause to its description:
- A. GROUP BY matches with I: Description I states "Is used to fetch some rows on the basis of common values in a column," which aligns with grouping related elements.
- B. HAVING matches with II: Description II states "Is used to specify conditions on rows with Group By clause," which defines the exact role of the HAVING clause.
- C. ORDER BY matches with III: Description III states "Is used to display data in an ordered form," which is the purpose of sorting records with ORDER BY.
- D. WHERE matches with IV: Description IV states "Is used to retrieve data that meets certain conditions," which describes row filtering prior to aggregation.
This matching results in the sequence: A-I, B-II, C-III, D-IV.
Looking at the options, this matches perfectly with option (B).
• Step 4: Final Answer:
The correct matching sequence is represented by option (B).
