SELECT DISTINCT still showing duplicates

Question

Yes, there are so many questions about this, but I was looking for half an hour, and I still have to find a solution.

So, I have a table like this:

And this is my request:

SELECT DISTINCT rengasID,leveys FROM renkaat ORDER BY leveys ASC

And as a result, I get:

If you have an idea, I fill in the field with it, but it still has duplicates.

What am I doing wrong?

Answer 1

If you need different leveys, just select this field:

SELECT DISTINCT leveys
FROM renkaat
ORDER BY leveys ASC

rengasid has a different meaning for each row.

The sentence distinctapplies to all columns returned regardless of the brackets.

EDIT:

If you need regasidthe result, use group by:

select leveys, min(regasid) as regasid
from renkaat
group by leveys
order by leveys asc;

. , , group_concat(). , .

Answer 2

rengasID - . , rengasID leveys.

, MySQL , .

, , "leveys" ( , ) . , . , group by id .

Answer 3

This is because you choose a combination of rengasIDand leveys. And what you get as a result is a great combination of the two.

To achieve what you are trying, see @GordonLinoff answer.