hiredates [message #373242] |
Thu, 05 April 2001 16:14 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
prat
Messages: 4 Registered: April 2001 Location: INDIA
|
Junior Member |
![prat.kp@gmail.com](/forum/theme/orafaq/images/google.png)
|
|
create a query that will display the total number of employees and of that total the number who were hired in 1980,1981,1982,1983.
table name emp
column name hiredate
|
|
|
Re: hiredates [message #373307 is a reply to message #373242] |
Tue, 10 April 2001 17:37 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Jini
Messages: 7 Registered: April 2001
|
Junior Member |
|
|
Hey try the enclosed statement and see if it works
select count(hiredate)from emp
where hiredate between 1980 and 1983;
|
|
|