Partially distinct select
37901
Select first row in each GROUP BY group?
22985
SQL query that gives distinct results that match multiple columns
67415
sql unique constraint on a 2 columns combination
69755
SELECT only latest record of an ID from given rows
21641
Remove duplicate entries, keeping latest only
65917
Combine multiple results in a subquery into a single comma-separated value
3673
SELECT statement using set Algebra
45813
QUERY - pivot multiple columns, variable number of rows
55676
SQL distinct for 2 fields in a database
86298
How do I (or can I) SELECT DISTINCT on multiple columns?
102911
Select rows which are not present in other table
17186
How to get only the unique results without having to sort data?
92992
MySQL: Conditionally selecting next and previous rows
110856
Number of ways to select $K$ people from $N$ people such that at least $r$ people are there in between them
129059
Select only those rows based on specific condition of user id
36815
SQL: how to select a single id ("row") that meets multiple criteria from a single column
34618
Select by partial string from a pandas DataFrame