Which commands do the same thing?
-
HAVING and GROUP BY
-
HAVING and QUALIFY
-
QUALIFY and QUANTIFY
-
QUALIFY and ORDER BY
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.