Query to retrieve the first 10 records inserted

[anup_daware]

I need to write a query/stored procedure where I want to get a specific number for records (say 10) from the database according to the time they are inserted into DB.
I store the insert time using SYSDATE and I want to retrieve the first ten inserted records (i.e. having smallest SYSDATE value) and then delete those from DB in one transaction.
If my table looks something like this:
RecordNum
RecordType
InsertTime
10
A
10/08/2007 14:20
20
B
10/08/2007 14:22


10/08/2007 14:27

 

[MrPaul]

TOP keyword

I assume this is a SQL Server database. In this case one approach is to use the TOP keyword:

SELECT TOP 10 RecordNum, RecordType, InsertTime FROM MyTable ORDER BY InsertTime ASC

Other database engines use different keywords, such as LIMIT in MySql.

Good luck