DISTINCT « Query « SQL Server / T-SQL Tutorial

1.12.1.A SELECT statement that eliminates duplicate rows
1.12.2.A summary query that uses the DISTINCT keyword
1.12.3.When the DISTINCT keyword is used, all duplicate values are eliminated before the function COUNT is applied.
1.12.4.Distinct with two columns
1.12.5.DISTINCT can be used only once in a SELECT list, and it must precede all column names in that list.
1.12.6.Correlated subquery using Distinct
1.12.7.Using SELECT DISTINCT or a GROUP BY statement in the inner query