|
Subject:
|
Query to retrieve the first 10 records inserted
|
|
Posted By:
|
anup_daware
|
Post Date:
|
8/6/2007 1:50:44 AM
|
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
30 A 10/08/2007 14:27
… … …
Please let me know how to go about it.
Thanks,
Anup
--Everything you can imagine is real.--
|
|
