| max |
Posted: Aug 13, 2008 01:34:50 AM |
Total Post: 14
Joined: Feb, 2008
|
i want those name of the employees who have worked together in a month or in year.
e.g.
name joining_date leaving date
max 1-july-2008 31-aug-2008
hitman 5-july-2008 5-sept-2008
stone 10-july-2008 10-sept-2008
ruchi 15-july-2008 15-sept-2008
so i want the result of days of those employees who have worked together
so the result wud be like dis
47 days acording to to above table
plzzzzz its urgent
thanks
nishant
|
|
|
 Vish |
| Posted: Aug 13, 2008 02:20:26 AM |  |
|
Total Post: 129
Joined: Jan, 2007
|
Dear Nishant
Please let me know what you are looking at output.
You want list of employees or no of days he worked?
Vishant
|
|
|
|
|
| max |
| Posted: Aug 19, 2008 05:04:45 AM | |
|
Total Post: 14
Joined: Feb, 2008
|
dear vishant,
actually i have solved dat query but actually i did by this
select minre_Date) - max(leave_date)
from employees;
thanks anyway for your reply
regards
nishant
|
|
|
|
|
| max |
| Posted: Aug 19, 2008 05:05:03 AM | |
|
Total Post: 14
Joined: Feb, 2008
|
dear vishant,
actually i have solved dat query but actually i did by this
select min(hire_Date) - max(leave_date)
from employees;
thanks anyway for your reply
regards
nishant
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
