Wednesday, February 11, 2009

SQL Select First and Last 100 Record

Select first 100 Records
SELECT RecordId
FROM Table
LIMIT 100


Select Last 100 Records
SELECT RecordId
FROM Table
ORDER BY RecordId DESC
LIMIT 100