Skip to content
Advertisement

Is there a way to distinct multiple columns in sql?

Is there a way to distinct multiple columns? When I tried to do it with p.name it says that there is an error that occurred.

Advertisement

Answer

If you want one row per NAME, then you can use ROW_NUMBER():

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