Skip to content
Advertisement

Insert every other row to a Column

I have this Table with one row Transaction Date the first row is the checkIn and the second one is the Checkout if we organized the result by date asc.

I need to pass the second row value to another column named Checkout. This table has at least 1000 records

Advertisement

Answer

Try using the query below

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