Skip to content
Advertisement

SQL Transpose for timestamps

I want to ask, how to make output below :

from data like this below :

with rules the ‘Clock_in’ is the earliest and ‘Clock_out’ is the latest one of the ‘Timestamps’ group by ‘NIP’

Advertisement

Answer

If you are using SQL server you can make sure of Cast and group by.

output:

enter image description here

User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement