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!

suppressing repeat value

652391Jul 29 2008 — edited Jul 30 2008

Hi i want to develop a query to suppress repeating value not using distinct
eg if one client have multiple customers if select clientno and custcode it will display
C0001 P00003
C0001 P00004
C0001 P59344
I want to suppress the repeating of Client no(C0001) in the sqloutput,how can i do that
rgds
roshi

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 27 2008

Added on Jul 29 2008

12 comments

2,827 views