Home Forums Article Discussions Article Discussions by Author Discuss content posted by Nakul Vachhrajani Using OVER with an Aggregate Function RE: Using OVER with an Aggregate Function

  • November 3, 2010 at 10:41 pm

    #1246375

    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