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: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 17 Feb 2005 02:17:02 -0800
Message-ID: <1108635422.471499.92060@f14g2000cwb.googlegroups.com>

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)?
>
> Thanx
> Michal

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.

Regards
/Rauf Received on Thu Feb 17 2005 - 04:17:02 CST

Original text of this message

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