Selecting duplicates only

gvee · #1 (**permalink**) 02-09-07, 08:46

I have tables as below

Employees(EmployeeNum, Department, Division ... )
Appr(UniqueID, EmployeeNum, ApprDate, ApprType ... )

Where one employee can have many records in the Appr table.
Basically, what I want is to pick out employees who have multiple records in the Appr table.

Is this at all possible?
Please ask any questions needed!

- GeorgeV

r937 · #2 (**permalink**) 02-11-07, 15:43

Code:

select EmployeeNum
     , Department
     , Division
  from Employees 
 where EmployeeNum in
       ( select EmployeeNum
           from Appr
         group
             by EmployeeNum
         having count(*) > 1 )

gvee · #3 (**permalink**) 02-14-07, 09:18

Perfecto!

<3

Internet Services

Web Development

Digital Marketing

Consumer Tech