Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise