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

�

�

�

 

Please let me know how to go about it.

Thanks,

Anup

[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 :cool: