Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: distinct

Re: distinct

From: vertigo <ax178_at_wp.pl>
Date: Thu, 17 Feb 2005 14:10:30 +0100
Message-ID: <cv2556$15n$1@atlantis.news.tpi.pl>

Rauf Sarwar wrote:

> vertigo wrote:
>

>>Hello
>>i have table with columns: empno, empname and salary.
>>
>>How should i ask to receive empno,empname and salary for distinct
>>empname (empno and salary could be the same)?

> What exactly are your trying to do? Most likely empno is unique in this
> table and probably part of the PK... which is correct since employee
> names and salary may not be unique BUT your statement "(empno and
> salary could be the same)" is contrary to that. What you are trying to
> extract does not make sense because what if there are 5 John Doe's and
> 5 Jane Doe's each. There only distinction is empno.

you're right - my statemant did not have sense.

Thanx
Michal Received on Thu Feb 17 2005 - 07:10:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US