RDBMS - Create a query that will display the total number of employees and of that total the number who were

GeekInterview.com > Tech FAQs > RDBMS

Go To First | Previous Question |

RDBMS | Question 18 of 18

Create a query that will display the total number of employees and of that total the number who were hired in 1980, 1981, 1982, and 1983. Give appropriate column headings.

Total Answers and Comments: 3

Last Update: May 23, 2008 Asked by: adnan

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

November 22, 2007 06:58:41

Chain Singh

RE: Create a query that will display the total number ...

The query is:

select count(*) as Totalnoofemployees, to_char(dateofjoining,'yyyy') as hiredyear from tablename
group by to_char(dateofjoining,'yyyy')

Is this answer useful? Yes | No

0 1

Overall Rating: -1

January 04, 2008 00:00:24

suganthi.m

Member Since: December 2007 Contribution: 1

RE: Create a query that will display the total number of employees and of that total the number who were hired in 1980, 1981, 1982, and 1983. Give appropriate column headings.

select count(*) as Totalnoofemployees, to_char(dateofjoining,'yyyy') as hiredyear from tablename

Is this answer useful? Yes | No

0 1

Overall Rating: -1

May 23, 2008 07:05:20

hemanth.6996

Member Since: May 2008 Contribution: 2

RE: Create a query that will display the total number of employees and of that total the number who were hired in 1980, 1981, 1982, and 1983. Give appropriate column headings.

select emp_id from employee_details group by emp_doj where emp_doj in (1980,1981,1982,1983);

Is this answer useful? Yes | No

Go To Top