OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » hiredates

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

hiredates [message #373243]

Thu, 05 April 2001 16:19

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

Report message to a moderator

Re: hiredates [message #373634 is a reply to message #373243]

Fri, 27 April 2001 14:34

Jaco
Messages: 23
Registered: August 2000

Junior Member

SELECT COUNT(*) FROM EMP WHERE HIREDATE BETWEEN ('01-JAN-1980') AND ('01-JAN-1983')

Report message to a moderator

Re: hiredates [message #373635 is a reply to message #373243]

Fri, 27 April 2001 14:34

Jaco
Messages: 23
Registered: August 2000

Junior Member

SELECT COUNT(*) FROM EMP WHERE HIREDATE BETWEEN ('01-JAN-1980') AND ('01-JAN-1983')

Report message to a moderator

Previous Topic:	Programmer asks how insert an image (BLOB) in VB 6.0
Next Topic:	updating a field using a join

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 01:09:12 CDT 2024