Hi,

I have small doubt in Group By query.

I want to display the total number of employees and, of that total, the number of employees hired in 1995,1996,1997 and 1998.

i.e it should look like this..

TOTAL 1995 1996 1997 1998
20 1 3 4 5

Please help me asap.


Thanks & Regards,

Gururaj.C.M.
Software Engineer,
BLUE CHIP COMPUTER CONSULTANTS PRIVATE LTD.,
Mobile No: +919845580082




!-- Virus-Free Mail Using PostMaster Enterprise AvAc & QuickHeal Engine --!

-------------------------------------------------------
Bluechip Computer Consultants Pvt Ltd, Bangalore, India

Oracle LazyDBA home page