Skip repeating values
from the Artful Common Queries page
You want to report all unique values of a column and skip all rows repeating any of these values.
SELECT col FROM foo GROUP BY col
Last updated 22 May 2024
</td></tr></table> <div style="float-left;display:inline-block;width:100%;"><br><br><hr></div><center><div style="color:#990000;display:inline-block;"><b><i>Return to <a href="../infotree/queries.html">the Artful Common Queries page</a></i></b></div></center><span style="float-left;"><hr></span><script type="text/javascript">new Image().src = "//counter.yadro.ru/hit?r"+escape(document.referrer)+((typeof(screen)=="undefined")?"":";s"+screen.width+"*"+screen.height+"*"+(screen.colorDepth?screen.colorDepth:screen.pixelDepth))+";u"+escape(document.URL)+";"+Math.random();</script> </body> </html>
