selecting only one row

[Guest_imported]

Hi,

I have 20000 records of employee_number and department
Some employees have multiple departments but I only want to select one
How do I do that?

 

[grega]

Sirhal, what do you only want to select one of? If you only want a list of employees, you can do;
[tt]
select distinct employee_number
from mytable
[/tt]

If you want the first employee/department for each employee ... that's a different story!

Greg.

 

[JeremyCionca]

Would that be possible? ... selecting the first employee/department for each employee?

 

[karluk]

The key issue seems to be which department you want. Something like the following would work, assuming you want the lowest department for a given employee.

select employee_number, min(department) from your_table
group by employee_number