SELECT DISTINCT with ORDER BY (*204)

SQL Server 6.5

ANSI-compliant. SELECT DISTINCT queries containing sort columns not included in the original select list in the ORDER BY clause are not supported.

SQL Server 6.0

SELECT DISTINCT queries containing sort columns not included in the original select list in the ORDER BY clause are supported.