List Question
20 TechQA 2024-02-01T13:08:45.687000Return only one element per unique ID with only latest joined record
161 views
Asked by Mike K
Postgresql - Distinct On Result
52 views
Asked by Anti Mafia
Min dates from group by postgresql
91 views
Asked by Jonibek
Select N latest rows per school, but skip duplicates from the same student
144 views
Asked by askingquestions
Is this index for SELECT DISTINCT ON wrong? Why the Seq Scan is still in plans?
46 views
Asked by Fred Hors
ORDER BY DESC with LIMIT doesn't return the newest rows, unless I ORDER BY twice
354 views
Asked by Kernel James
Using DISTINCT ON for a column of type timestamp to extract the most recent value for each day
227 views
Asked by MehdiB
DISTINCT ON slow for 300000 rows
192 views
Asked by MehdiB
how to apply distinct and group by in django or in postgres?
39 views
Asked by Noyon Islam
PostgreSQL select distinct JSONB poor performance
90 views
Asked by Johnny Metz
PostgreSQL: SELECT DISTINCT ON expressions must match initial ORDER BY expressions
4.2k views
Asked by Johnny Metz
SQL left Join with DISTINCT ON returns duplicate rows
424 views
Asked by Diogo
What is the BigQuery equivalent of PostgreSQL's `DISTINCT ON`?
3k views
Asked by François Leblanc
How to use Distinct On with COALESCE
523 views
Asked by Martin
How to remove duplicates in query for google big query by a subset of returned rows, and keep first?
2.2k views
Asked by SantoshGupta7
Postgresql update 200 random records
776 views
Asked by ClaskoTheKnight
PostgreSQL SELECT result with a distinct ids that prefers specific values from another table
1.1k views
Asked by bezdroznik
How to pull max timestamp for distinct sets and subsets
291 views
Asked by Number1Rock
Typeorm order by after distinct on with postgresql
548 views
Asked by I.Bozcan
How to use DISTINCT ON but ORDER BY another expression?
99 views
Asked by pinkfloyd90