>Hi everybody,
>
>I have a complex query to get duplicates. I want to change all records (using SCAN/ENDSCAN) in the main table except for the latest record in each group. I can write a procedural code, but I'm wondering if there is a way to get them by SQL?
>
>I guess the procedural code would be simpler anyway.
>
>Thanks in advance.
Do you have unique id in each record? Can you show an example of the structure of your main table?