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.
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