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.