i have a table having records are saving in this format
EMPCODE PUNCH_DATE PUNCH_TYPE
E101 2020-07-25 15:44:23 IN
E101 2020-07-25 15:45:14 IN
E101 2020-07-25 15:45:43 IN
E101 2020-07-25 15:46:07 IN
E101 2020-07-25 15:47:14 OUT
E101 2020-07-25 15:47:22 IN
E101 2020-07-25 15:48:27 OUT
E101 2020-07-25 15:49:58 OUT
E101 2020-07-25 15:50:19 IN
but i need data in one row of a single date. kindly provide the sql query to show the above data in below format.
EMPCODE IN IN IN IN OUT IN OUT OUT IN
E101 2020-07-25 15:44:23 2020-07-25 15:45:14 2020-07-25 15:45:43 2020-07-25 15:46:07 2020-07-25 15:47:14 2020-07-25 15:47:22 2020-07-25 15:48:27 2020-07-25 15:49:58 2020-07-25 15:50:19
What I have tried:
i try to use pivot option but could't successes