|
I am facing some problem. Please help me ! I have a attendance table, Every day i entry employee present and absent time and one status column to maintain employee's present or absent status.
I entry one month data at that table and I wish to write a query , that can show individual employee record with in one row..as like this example table ....
My Actual Table
EmpNo Name Status Date
----------- --------- ---------- ---------
1000 Mr. Joy Sick Leave 01-Jan-03
1000 Mr. Joy Present 02-Jan-03
1000 Mr. Joy Absent 03-Jan-03
1000 Mr. Joy Present 04-Jan-03
My SQL query should be display ....
EmpNo Name Present Absent Sick Leave
----------- --------- ---------- ----------- --------------
1000 Mr. Joy 2 1 1
Please, Help me " How can i write this type of SQL Query "
Thanks and Beast Regards ...
G.K.M. Shafiul Alam Bhuiyan
(Computer Programmer)
| 