• MyDoggieJessie (3/16/2013)


    I'm going to assume there's more rows in the table than 2, and you want just the last 2 of them ordered in ascending order?

    Try:

    ;WITH MyData AS (

    SELECT TOP 2 *

    FROM dbo.NFFeeds

    ORDER BY id DESC

    )

    SELECT * FROM MyData

    ORDER BY id

    thanks dear 'MyDoggieJessie ' ... it's that i want.