Hi:

If select distinct specified order by item must appear in the select list and there will be error message as follows:

Msg 145, Line 15 St 1