Help Wanted: How to write a single select clause for mutiple counts

Hi,

There is a table like this:

0124		1-OCT-95
0342		2-OCT-95
3213            11-NOV-95
4466		30-NOV-95
0990		14-NOV-95
0345            2-SEP-95

Users want to know how many students registed in Oct, How many in Nov and so on.

I used UNION ALL to combine the rows returned by several SELECTs each of which count a tatol number for ecah month. The result look like:

2
3
1

But It isn't What I want.

Can I write a single select clause to get the result in one row. The result should looks like

OCT     NOV      SEP
2       3        1

Do you think it is posible?

Thank you very much!!!

Jiang Honng Received on Mon Apr 01 1996 - 00:00:00 CEST