Question

Return only one element per unique ID with only latest joined record

score 161 · Answer 1 · 2024-02-01T13:08:45.687000

161

Views

Return only one element per unique ID with only latest joined record

Published on 01 February 2024 at 13:08

score 52 · Answer 2 · 2023-12-20T10:12:48.243000

52

Views

Postgresql - Distinct On Result

Published on 20 December 2023 at 10:12

score 91 · Answer 3 · 2023-12-01T08:59:43.363000

91

Views

Min dates from group by postgresql

Published on 01 December 2023 at 08:59

score 144 · Answer 4 · 2023-10-14T19:33:08.880000

144

Views

Select N latest rows per school, but skip duplicates from the same student

Published on 14 October 2023 at 19:33

score 46 · Answer 5 · 2023-03-27T08:29:46.417000

46

Views

Is this index for SELECT DISTINCT ON wrong? Why the Seq Scan is still in plans?

Published on 27 March 2023 at 08:29

score 354 · Answer 6 · 2022-12-22T08:56:50.097000

354

Views

ORDER BY DESC with LIMIT doesn't return the newest rows, unless I ORDER BY twice

Published on 22 December 2022 at 08:56

score 227 · Answer 7 · 2022-12-16T18:47:11.603000

227

Views

Using DISTINCT ON for a column of type timestamp to extract the most recent value for each day

Published on 16 December 2022 at 18:47

score 192 · Answer 8 · 2022-12-15T23:22:23.157000

192

Views

DISTINCT ON slow for 300000 rows

Published on 15 December 2022 at 23:22

score 39 · Answer 9 · 2022-11-16T12:26:33.653000

39

Views

how to apply distinct and group by in django or in postgres?

Published on 16 November 2022 at 12:26

score 90 · Answer 10 · 2022-11-14T04:58:47.277000

90

Views

PostgreSQL select distinct JSONB poor performance

Published on 14 November 2022 at 04:58

score 4.2k · Answer 11 · 2022-11-14T03:40:25.330000

4.2k

Views

PostgreSQL: SELECT DISTINCT ON expressions must match initial ORDER BY expressions

Published on 14 November 2022 at 03:40

score 424 · Answer 12 · 2022-08-29T20:01:02.873000

424

Views

SQL left Join with DISTINCT ON returns duplicate rows

Published on 29 August 2022 at 20:01

score 3k · Answer 13 · 2022-08-16T14:28:37.287000

3k

Views

What is the BigQuery equivalent of PostgreSQL's `DISTINCT ON`?

Published on 16 August 2022 at 14:28

score 523 · Answer 14 · 2022-06-07T17:37:58.037000

523

Views

How to use Distinct On with COALESCE

Published on 07 June 2022 at 17:37

score 2.2k · Answer 15 · 2022-05-28T11:32:50.023000

2.2k

Views

How to remove duplicates in query for google big query by a subset of returned rows, and keep first?

Published on 28 May 2022 at 11:32

score 776 · Answer 16 · 2022-04-21T22:41:44.333000

776

Views

Postgresql update 200 random records

Published on 21 April 2022 at 22:41

score 1.1k · Answer 17 · 2022-04-03T17:30:14.903000

1.1k

Views

PostgreSQL SELECT result with a distinct ids that prefers specific values from another table

Published on 03 April 2022 at 17:30

score 291 · Answer 18 · 2022-02-26T01:54:09.827000

291

Views

How to pull max timestamp for distinct sets and subsets

Published on 26 February 2022 at 01:54

score 548 · Answer 19 · 2022-01-30T08:31:56.920000

548

Views

Typeorm order by after distinct on with postgresql

Published on 30 January 2022 at 08:31

score 99 · Answer 20 · 2021-11-24T12:06:18.777000

99

Views

How to use DISTINCT ON but ORDER BY another expression?

Published on 24 November 2021 at 12:06

List Question

Return only one element per unique ID with only latest joined record

Postgresql - Distinct On Result

Min dates from group by postgresql

Select N latest rows per school, but skip duplicates from the same student

Is this index for SELECT DISTINCT ON wrong? Why the Seq Scan is still in plans?

ORDER BY DESC with LIMIT doesn't return the newest rows, unless I ORDER BY twice

Using DISTINCT ON for a column of type timestamp to extract the most recent value for each day

DISTINCT ON slow for 300000 rows

how to apply distinct and group by in django or in postgres?

PostgreSQL select distinct JSONB poor performance

PostgreSQL: SELECT DISTINCT ON expressions must match initial ORDER BY expressions

SQL left Join with DISTINCT ON returns duplicate rows

What is the BigQuery equivalent of PostgreSQL's `DISTINCT ON`?

How to use Distinct On with COALESCE

How to remove duplicates in query for google big query by a subset of returned rows, and keep first?

Postgresql update 200 random records

PostgreSQL SELECT result with a distinct ids that prefers specific values from another table

How to pull max timestamp for distinct sets and subsets

Typeorm order by after distinct on with postgresql

How to use DISTINCT ON but ORDER BY another expression?

Trending Questions

Popular # Hahtags

Popular Questions