SQL Language (MOSC)

MOSC Banner

Matrix Query for Attendance record

edited Dec 21, 2013 8:13PM in SQL Language (MOSC) 4 commentsAnswered ✓
Hi all, 
I have following tables, where i want to create matrix query where on top rows it shows date column, left column shows employee name and in matrix it calculate number of hours (time_out-time_in) 

Emplyee_master 
empno number 
empname varchar2 

Employee_detail 
empno number 
attendance_date date
time_in date
time_out date 

Date jan-01 jan-02 jan-03 jan-04 jan-05 ...... jan-31
Employee_name   
Emp A
Emp B
Emp C
Emp D
Emp E
Emp F

Regards, 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center