Re: Suppressing Duplicate Values in Oracle Reports

ORA-LEARNER wrote:
> Hi there,
> It seems to be such a basic requirement in reporting world but don't
> know how to do this in Oracle reports 6i.
> I need to suppress the duplicate values in the report output:
>
> Current O/P Desired OUTPUT
> ___________________________________________________
> COL1 VAL1 COL1 VAL1
> COL1 VAL2 VAL2
> COL1 VAL3 VAL3
>
> Any idea?

SELECT DISTINCT ...

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)