Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  re: need to count employers hired per year

Author  Topic  msa969 Starting Member 13 Posts Posted - 2001-10-27 : 11:45:13 Assuming I have a table emp with the following columns. empno | name | hiredate How could I calculate a total number of employers hired, and then total hired grouped by years? i.e. something like Total 1989 1999 ----- ----- ---- 36 18 20 Please help as I have tried using count(), decode and other combinations. With no luck