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
)
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
)