I need to compare data that is associated with the individual members of groups of employees and find differences amoung each of the employees belonging to the same group. Please see the last page of the attached example table. If anyone could help I would greatly appreciate it!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Query compares group members and finds unique data?
- Thread starter cdgeer
- Start date
traingamer
Programmer
You could start with
to find your differences and go from there.
What have you tried so far?
Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill
Code:
Select Supervisor, AmisysScreen, Count(EEID)
from YourTable
order by Supervisor, AmisysScreenWhat have you tried so far?
Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
