Re: distinct

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