Test your knowledge of HAVING

The following query from the NBA Season 2017-2018 database returns the total points contribution, of a teams Centers, where total points are greater than 2500.

SELECT Team, 
    SUM(TotalPoints) AS TotalCPoints
FROM PlayerStats
WHERE Position = 'C'
GROUP BY Team
HAVING SUM(TotalPoints) > 2500;

Copy and paste the above query into the query console and select Run Code to check the results.

When using HAVING in a query which one of the following statements is FALSE?

संभावित उत्तर

When filtering a numeric column, HAVING must be used with an aggregate function, for example: SUM(), COUNT(), AVG()…

WHERE and HAVING can be used in the same query.

Use HAVING with, and after, GROUP BY.

HAVING and WHERE produce the same output, so it doesn't matter which one you use.

अभ्यास

Test your knowledge of HAVING

निर्देश

संभावित उत्तर

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}अभ्यास

निर्देश

संभावित उत्तर

अभ्यास