Multiple choice technology databases

Which commands do the same thing?

  1. HAVING and GROUP BY

  2. HAVING and QUALIFY

  3. QUALIFY and QUANTIFY

  4. QUALIFY and ORDER BY

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Both HAVING and QUALIFY filter results after aggregation. HAVING filters grouped aggregate results, while QUALIFY filters results based on window function calculations. In Teradata SQL, they serve similar filtering purposes for aggregated data.