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
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