Comments by Member 10438440

Member 10438440 30-Jul-20 7:43am View

Ok. I have sql table EMPPUNCH_MASTER having column names are as - EMPCODE, PUNCH_DATE, PUNCH_TYPE

Record in the table is in below 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:47:14 OUT
E101 2020-07-25 15:47:22 IN
E101 2020-07-25 15:48:27 OUT

but i require record in below format -
EMPCODE IN IN OUT
E101 2020-07-25 15:44:23 2020-07-25 15:45:14 2020-07-25 15:47:14

here, one employee record shown in one row. i want this.
i try several options but couldn't find any solution.

Member 10438440 30-Jul-20 7:26am View

aggregate function makes issue.

Member 10438440 30-Jul-20 7:24am View

yes i need to transpose rows into column. like
EMPCODE IN IN OUT
E101 punchtime punchtime punchtime

Comments by Member 10438440 (Top 3 by date)