SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL to get unique record

884364Aug 30 2012 — edited Sep 1 2012

EVENT_ID TRANSFER_ID
-------------- ------------------
44745 693420
44744 693420
44743 603420
44742 603420
44741 543420
44740 543420
44739 543421
44738 543421

How can I get list of unique TRANSFER_ID?

EVENT_ID TRANSFER_ID
-------------- ------------------
44745 693420
44743 603420
44741 543420
44739 543421

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 29 2012

Added on Aug 30 2012

#sql, #value

9 comments

167 views