Home Forums SQL Server 2008 T-SQL (SS2K8) Help with Max function RE: Help with Max function

  • August 22, 2013 at 9:52 am

    #1644014

    The MAX statement will only return one single value. You can get the desired results using the TOP clause:

    SELECT TOP 2

    change_id

    FROM table_a

    ORDER BY change_id DESC

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **