Row filtering with HAVING
In some cases, using HAVING
, instead of WHERE
, as a filter condition will produce the same results. If filtering individual or ungrouped rows then it is more efficient to use WHERE
.
In this exercise, you want to know the number of players from Latin American countries playing in the 2017-2018 NBA season.
This exercise is part of the course
Improving Query Performance in SQL Server
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
