How can I select a distinct value for only one columb but retrieve all my other columns?
Basically, I have this data:
Sequence, Name, Code, Value, PURCHYN
1, TestName, TestCode, TestValue, TestPurchyn
2, OtherName, OtherCode, OtherValue, OtherPurchyn
3, TestName, TestCode, TestValue, TestPurchyn
I want to retrive all fields from the above but do a distinct on Code and return the highest sequence of the duplicates...
This is in Oracle...
Any advise please?