With the distinct keyword with single and multiple column names, you get distinct records: SELECT … See more

This is the most simple and straight forward, but also the most limited way: SELECT DISTINCT word, num FROM dupes ORDER BY word, num; /* word|num| ----|---| aaa … See more

Grouping allows you to add aggregated data, like the min (id), max (id), count (*), etc: SELECT word, num, min (id), max (id), count (*) FROM dupes GROUP BY word, num ORDE… See more

Using a subquery, you can first identify the duplicate rows to ignore, and then filter them out in the outer query with the WHERE NOT IN (subquery) construct: * Find the hi… See more

In the Common Table Expression (CTE), select the ROW_NUMBER(), partitioned by the group column and ordered in the desired order. Then SELECT only the records tha… See more