Getting all unique pairs without GROUP BY
133138
Selecting more then one column when groupBy is present (db_select) - Drupal 8 added 'ONLY_FULL_GROUP_BY'
12087
How to drop unique in MySQL?
127084
Returning the 'last' row of each 'group by' in MySQL
38452
SQL Not A Single Group Group Function
21871
In Python, what is the fastest algorithm for removing duplicates from a list so that all elements are unique *while preserving order*?
93921
Select groups based on number of unique / distinct values
42491
How do I efficiently get "the most recent corresponding row"?
146592
Is there a faster way to get UNION ALL behavior in Postgres?
18188
Is there a no-duplicate List implementation out there?
100486
How to select unique records by SQL
71713
PostgreSQL - "DISTINCT ON" and "GROUP BY" syntax
137172
How to get distinct characters?
118170
SQL -- How is DISTINCT so fast without an index?
8801
Can I combine the results from multiple columns into a single column without UNION?
62482
how to select only row with max sequence without using a subquery?
34883
Remove specific duplicates (all but latest)
41569
Extracting Unique values from a list