I have data in column now i want to separat it status wise one col Status(1)IN and Col(2)Out
EmpID
|
DateTime |
StatusINOUT |
1 |
2018-05-26 08:44 |
1 |
1 |
2018-05-26 08:44 |
2 |
2 |
2018-05-28 08:44 |
1 |
2 |
2018-05-28 12:44 |
2 |
1 |
2018-05-21 08:44 |
1 |
1 |
2018-05-21 10:44 |
2 |
2 |
2018-05-23 08:44 |
1 |
2 |
2018-05-23 08:44 |
2 |
Now i want to display Status wise INTIME(1) and OUTTIME(2) it as below
Empid |
INTIME(1) |
OUTIME(2) |
1 |
2018-05-26 08:44 |
2018-05-26 08:44 |
2 |
2018-05-28 08:44 |
2018-05-28 12:44 |
1 |
2018-05-21 08:44 |
2018-05-21 10:44 |
2 |
2018-05-23 08:44 |
2018-05-23 08:44 |