Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Wednesday, 11 May 2016

Employee Absence And Other Info Details

SELECT paa.business_group_id, papf.full_name, paa.date_start leave_start_date,
       paa.date_end leave_end_date, paa.occurrence, paa.time_end,
       paa.time_start, paa.absence_days, paa.absence_hours,
       paa.abs_information_category, paa.abs_information2,
       paa.abs_information3, paa.abs_information4
  FROM per_absence_attendances paa, per_all_people_f papf
   WHERE 1 = 1
     AND papf.person_id = paa.person_id
     AND TRUNC (paa.date_start) BETWEEN TRUNC (papf.effective_start_date)
                                    AND TRUNC (papf.effective_end_date)
     AND papf.business_group_id = paa.business_group_id
ORDER BY papf.employee_number, paa.date_start;


Share this article :

2 comments:

  1. Hello There,


    So bloody thorough! Ah! So happy and blessed out! I feel redeemed by reading out Employee Absence And Other Info Details. Keep up the good work!

    I have this requirement where I have to execute a sql query based on output of another query, something like given in example below :

    I read multiple articles and watched many videos about how to use this tool - and was still confused! Your instructions were easy to understand and made the process simple.


    Kind Regards,
    Niha

    ReplyDelete
  2. Hello There,

    Zoooooooom! That’s how speedy and easy this read was! Looking forward to more of such powerful content on Employee Absence And Other Info Details !

    I have an excel which is in csv format. I am trying to import this data to the table using sql developer.

    But I get the same number throughout the full column as 100005000000000.

    It is the field with datatype NUMBER(25,0). Actual number is different.

    But nice Article Mate! Great Information! Keep up the good work!

    Thank you,
    Preethi

    ReplyDelete