Wednesday, November 12, 2008

Last N rows from SQL Server Table

Retrieving last 5 rows from a table

SELECT TOP (SELECT Count(*) FROM Person) * FROM Person
Except
SELECT TOP (SELECT Count(*)-5 FROM Person) * FROM person


OR

SELECT TOP (SELECT Count(*) FROM Person) * FROM Person
WHERE PersonName NOT IN(
SELECT TOP (SELECT Count(*)- 5 FROM Person) PersonName FROM person
)

No comments: