Hello everybody,

I need to write a delete statement to delete all the records in a table except last 100 records. I have an autogenerated ID field, so you can say delete all the records except those 100 with greatest value in ID field.

Any idea??

Thanks.