UNION or DISTINCT()?
When deciding whether to use DISTINCT()
or UNION
in a query to remove duplicate rows, which of the following questions would you NOT ask yourself?
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
