Delete first record in a table 1

[gal4y]

I would like to know the SQL to delete the first record in a table/query.

I need only keep 10 records (calculation data) in a table. When it gets to 11 records I would like to delete the first record.

What is the SQL to do that. The table is called tblzeroize with an ID field and time field.

Thanks for any assistance in advance.
Greg

 

[Golom]

Try

   Delete * From tbl Where tbl.TimeField = MIN(tbl.TimeField)

 

[gal4y]

Thank you so much!!