Skip to content
Advertisement

oracle query for merge to row into one

I have a table with which showing in_time and out_time with gate number at separate row, but I wanted to show up this in one row, so I need to merge both rows into one here is result for this

Here what I expected

can you please give a solution for this

Advertisement

Answer

We need to link in times with out times for each employee, something like the following should point you in the right direction:

See demo here: DB Fiddle

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