Re: PLSQL syntax question

From: Markus Stuhlpfarrer <mstuhlpfarrer_at_hollomey.com>
Date: Tue, 28 Aug 2001 06:36:27 GMT
Message-ID: <3B8B3BA4.B987D7D4_at_hollomey.com>


try distinct

SELECT DISTINCT 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 Jon Schlatter wrote:

> 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 Tue Aug 28 2001 - 08:36:27 CEST

Original text of this message