Re: PLSQL syntax question

[Quoted] I tried this and it is not giving me the type of results I need. Let me see [Quoted] if I can explain better. Currently my report looks like this.

Client1 Project1 Description
Client1 Project2 Description
Client1 Project3 Description
Client2 Project1 Description
Client2 Project2 Description
Client2 Project3 Description

What I want to see is like this.

Client1 Project1 Description

               Project2    Description
               Project3    Description
Client2    Project1    Description
               Project2    Description
               Project3    Description

Can I do this with SQL Plus - PL/SQL?

"Ranga Chakravarthi" <ranga_at_cfl.rr.com> wrote in message news:xmvi7.78461$0X.15154363_at_typhoon.tampabay.rr.com...
> If you are using SQL*Plus, try the break command
> break on customer_ref
>
> SQL> break on deptno
> SQL> select deptno, ename from emp order by deptno;
>
> DEPTNO ENAME
> ---------- ----------
> 10 CLARK
> KING
> MILLER
> 20 SMITH
> ADAMS
> FORD
> SCOTT
> JONES
> 30 ALLEN
> BLAKE
> MARTIN
> JAMES
> TURNER
> WARD
>
> 14 rows selected.
>
> SQL>
> "Jon Schlatter" <*jon-schlatter_at_stamats.com> wrote in message
> news:tokr58jmtcfu84_at_corp.supernews.com...
> > I need to perform a select statement that does a group by and the
> supresses
> > duplicate entries. I am writing a job status report and have the
following
> > select statemenet written.
> >
> > SELECT PA_JOB.PROJECT_NO, PA_JOB.JOB_NO, PA_JOB.DES1,
> > PA_JOB.JOB_MANAGER_REF, PA_JOB.EST_COMPLETION_DATE,
PA_JOB.DEADLINE_DATE,
> > PA_JOB.CUSTOMER_REF, PA_JOB.UD_NOTE
> > FROM K.PA_JOB PA_JOB
> > WHERE ( PA_JOB.STATUS IN ('A','I') )
> > ORDER BY PA_JOB.CUSTOMER_REF ASC, PA_JOB.JOB_MANAGER_REF ASC,
> > PA_JOB.PROJECT_NO ASC, PA_JOB.JOB_NO ASC
> >
> > All the data shows up properly, but now I need to supress duplicate
> entries
> > on the PA_JOB.CUSTOMER_REF field for readability. Can anyone help me?
> >
> > TIA
> > Jon
> >
> >
> >
> >
>
>
Received on Mon Aug 27 2001 - 20:45:14 CEST