Query to display the difference of period for an employee.

  • Thread starter Thread starter vprnath
  • Start date Start date
V

vprnath

You are requested to enable me to write a query to find the in between period
('ie' in months and days) for an employee being absent in more than a month
of a year , ex: MR. R.SATYA RAO IS ABSENT CONTINUOUSLY

empno emp_name leaveDesc FromDD ToDD
07320589 R. SATYA RAO ABSENT 01/04/2008 30/04/2008
07320589 R. SATYA RAO ABSENT 01/05/2008 31/05/2008
07320589 R. SATYA RAO ABSENT 01/06/2008 30/06/2008
07320589 R. SATYA RAO ABSENT 01/07/2008 30/07/2008
07320589 R. SATYA RAO ABSENT 01/08/2008 31/08/2008
 
Do you mean that you want to find what days the employee is not absent,
during a specific period? so that what would be returned by the query is a
list of dates?

Do you want this query to run for more than one person at a time, or just
one at a time?

Put some records in your sample data, where R.Satya Rao is not absent, then
show us what you would like the output to be.
 
Back
Top