We have to delete records from a table where the only definitive way to identify those records is by viewing the date encoded in the COUNTER value used as the row id when they were loaded. What would be the command to delete only those records in table PATN where the year encoded in id = 2005?
The SQL would be:
delete from PATN where id >= '2005-01-01' and id < '2006-01-01'