MS SQL: order by fields not present in select list when using distinct...

Description

In case "distinct" is used the current "select 0" concept used as default sorting throws an error.
If changing to "select 1" this means it will automatically sort by the first column in the select list.

Environment

None

Assignee

Unassigned

Reporter

Dominic Watson

Labels

None

Accepted

Yes

Fix versions

Priority

Medium
Configure