I want to remove duplicate rows return from a SELECT Query in Postgres I have the following query <pre class="prettyprint"><code>SELECT DISTINCT name FROM names ORDER BY name </code></pre> But this somehow does not eliminate duplicate rows?

Eliminating Duplicate rows in Postgres

I want to remove duplicate rows return from a SELECT Query in Postgres

I have the following query

SELECT DISTINCT name FROM names ORDER BY name

But this somehow does not eliminate duplicate rows?

708

asked Dec 18 '22 07:12

Maybe something with same-looking-but-different characters (like LATIN 'a'/CYRILLIC 'а')

answered Dec 27 '22 20:12

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!