I have a table contains order information like below:
As we can see from that table, each order_no has several duplicates. So what I want is to keep only one row for each order_no (no matter which one it is)
Is anyone knows how to do this? (FYI, I am using Oracle 10)
See Question&Answers more detail:os