| hiredates [message #373242] |
Thu, 05 April 2001 16:14  |
prat
Messages: 4
Registered: April 2001
Location: INDIA
|
Junior Member |
|
|
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  |
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;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
