Skip to content
Advertisement

oracle SQL Concatenate 2 columns based on condition

let’s say i have a table :

i want to concatenate based on ID , if the next row has the same id add both names like below :

Thanks .

Advertisement

Answer

You can do:

See running example at SQL<>Fiddle.

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