View previous topic :: View next topic
|
Author |
Message |
sivatechdrive
Active User
Joined: 17 Oct 2004 Posts: 191 Location: hyderabad
|
|
|
|
Hi all
There are 2 fields in my table and I have the data in my table as below
PROJCODE EMPNAME
====================
NAL001 SIVA
NAL001 PRASAD
NAL001 RAMESH
NAL001 SIVA
NAL001 RAMESH
GAL001 ABC
GAL001 ABC
GAL001 ABC
GAL001 ABC
GAL001 ABC
PAL001 CAD
PAL001 CAD
PAL001 NSC
PAL001 NSC
PAL001 NSC
THERE ARE 5 EMPLOYEES FOR EACH PROJECT & i WANT THE COUNT OF EMPLOYEES WITH OUT DUPLICATES
PROJCODE COUNT
NAL001 3 (AS SIVA,RAMESH ARE REPEATING)
GAL001 1 (AS ABC IS THE ONLY THING PRESENT)
PAL001 2 (AS CAD,NSC ARE REPEATING)
PLEASE HELP ME
THANKS N REGARDS
PRASAD |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
Code: |
SELECT PROJCODE, COUNT(*) FROM
(SELECT DISTINCT PROJCODE, EMPNAME FROM TABLE) A
GROUP BY PROJCODE;
|
|
|
Back to top |
|
|
muthuvel
Active User
Joined: 29 Nov 2005 Posts: 217 Location: Canada
|
|
|
|
This may help you
Code: |
Select PROJCODE,COUNT(DISTINCT EMPNAME )
From Table A |
Please off CAPS before you post |
|
Back to top |
|
|
|