Home » RDBMS Server » Server Administration » Count broken down By month. URGENT!!!!!!!!!!!!!!!!!!!!!!!!!
Count broken down By month. URGENT!!!!!!!!!!!!!!!!!!!!!!!!! [message #373382] Fri, 13 April 2001 10:19
aish74
Messages: 19
Registered: March 2001
Junior Member
I want SQL TO COUNT the no of employees worked in the particular division for a particular month. It should be broken down BY division AND month.

something LIKE the following:

Division JAN FEB MAR APR

A 10 9 11 7
B 3 6 12 8
C 4 4 4 4

In the month of Jan the no of working employees In division "A" are 10 and 9 in FEB .

Similarly In the month of Jan the no of working employees In division "B" are 3 and 6 in FEB .

COuld any body help me .
Its URGENT please

Report message to a moderator

Previous Topic: Re: help with logic
Next Topic: Count broken down By month. URGENT!!!!!!!!!!!!!!!!!!!!!!!!!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 11:27:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.