• Thanks for the sample data Dwain.

    Another option: -

    SELECT *

    FROM @T

    EXCEPT

    SELECT TOP 2 *

    FROM @T

    ORDER BY Column1;

    In SQL Server 2012, you could use the OFFSET command, which I think is like this (untested, as I don't have access to SQL Server 2012 atm): -

    SELECT *

    FROM @T

    ORDER BY Column1

    OFFSET 2 ROWS;


    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/