Please help me to create database on the number of employees.

Asked By ernie 0 points N/A Posted on - 11/01/2011

Can you help me set up database on the number of employees working on a particular day? In addition, it should also indicate the employee’s hiring date and termination date using the format MM/DD/YYYY.

• Status: Open
• Question Views: 818
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Databases

Answered By lee hung 75 points N/A #99057

Please help me to create database on the number of employees.

Hello Ernie,

You have not stated which kind of language that you want the database in, and therefore I will  give you any language which I hope will be of help to you.

In Oracle SQL, the employee database that you want to create should be something like the following, according to what you have specified in the question:

SELECT COUNT(date_hired WHERE date_hired LIKE '%100') "2000",

COUNT(date_hired WHERE date_hired LIKE '%96') "2001"
FROM EMPLOYEES
GROUP By date_hired ;

I am just assuming that you have 100 employees, and the other details are assumptions too, but you can customize them to fit your company situation.

Hope this helps.

__

Regards
Lee Hung

About lee hung

Questions
3

Answers
1451

Best Answers
463

• Vote Up 0 Vote Down

• Posted on - 11/27/2011
• Question Category: Misc Databases