Do you want to find out how to avoid duplicates in the results of a SQL SELECT query? This article will show you how. Simply use the DISTINCT clause and between the SELECT clause and the fields.
I've got a query that looks something like this:<pre class="ip-ubbcode-code-pre">SELECT DISTINCT item FROM sometable</pre>So I select distinct to remove duplicates ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback