|
|
| Author |
Message |
sivatechdrive
Active User
Joined: 17 Oct 2004
Posts: 163
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 |
|
 |
References
|
 Posted: Tue Nov 27, 2007 7:03 pm Post subject: Re: Query needed |
|
|
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 985
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: 179
Location: Chennai
|
|
|
|
This may help you
| Code: |
Select PROJCODE,COUNT(DISTINCT EMPNAME )
From Table A |
Please off CAPS before you post |
|
| Back to top |
|
|
|
|
