Skip to content
Advertisement

Left join only on first row

I have the following sample query:

and I’d like the following output

I read many questions on the similar topic but I wasn’t able to make it work.

Advertisement

Answer

You can use row_number():

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