Skip to content
Advertisement

SELECT DISTINCT ordering rows by order of appearance of the field

I have this data

And I need to do something like SELECT DISTINCT obtaining the data in order of appearance and not in the ascending order by default that is obtained.

If I do a SELECT DISTINCT I get this:

Here the code:

The result I need is like this:

I tried some like this, but It doesn’t work, because the order is variable:

Advertisement

Answer

I think you just want:

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