Forum Discussion

TDys's avatar
TDys
Frequent Visitor
6 years ago
Solved

Remove Duplicates saving one with higer value

Hi 

 

Ho do I remove duplicates for same SERIALID and SAME DATE saving only one with higher SMU value. Table has more than 1000 SERIALID. Some SERIALID do not have double entries.

 

Thank You in advance.

 

Need Help
  • VasTg's avatar
    VasTg
    6 years ago

    @TDys

    Here's the entrance.

    image.png

    Here's the exit:

    image.png

    If it helps, mark it as a solution

    Congratulations are also good

3 Replies