Home Forums SQL Server 2008 SQL Server 2008 - General how to find max amount RE: how to find max amount

  • August 26, 2010 at 10:23 am

    #1212411

    You can use ROW_NUMBER() with PARTITION clause.

    http://msdn.microsoft.com/en-us/library/ms186734.aspx