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

vertigo wrote:
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

Rauf Sarwar wrote:

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

Thanx
Michal