Re: PLSQL syntax question
Date: Mon, 27 Aug 2001 17:23:41 GMT
Message-ID: <xmvi7.78461$0X.15154363_at_typhoon.tampabay.rr.com>
[Quoted] 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 - 19:23:41 CEST