Microsoft Technologies: Clauses in SQL Server (SELECT,DISTINCT, TOP, FROM, WHERE, GROUP BY, HAVING, ORDER BY, NOT IN, IN , EXIST, BETWEEN, OVER ,OUTPUT)
SQL Server SELECT DISTINCT
Applying Select Distinct to One Column Only
SQL DISTINCT and TOP in Same Query - Essential SQL
getting same top 1 result in sql server - Stack Overflow
SQL SELECT DISTINCT Examples
sql server - DISTINCT on one column and return TOP rows - Database Administrators Stack Exchange