Limit record count

Hi,

I need to write a maintenance function to delete oldest records of a table, leaving only a certain number of records, say 50.  The task should run once per day.  How can I write it? 
The oldest record carries the smallest ID.

Thanks a lot!
Sean