Tag: greatest-n-per-group

Found 153 results for 'greatest-n-per-group'.

1) postgresql - Left join without duplicate rows
2) postgresql - Is it possible to select distinct values in a json document using PostgreSQL?
3) postgresql - Delete duplicate records with no change in between
4) postgresql - Optimize query to find top N users who commented on a post
5) postgresql - How to make DISTINCT ON faster in PostgreSQL?
6) sql-server - Selecting one row from each group based on a Varchar field
7) postgresql - Unnest ids from arrays based on priority with no duplication
8) postgresql - SELECT rows from table one by one, comparing one column values with values in an array
9) postgresql - Aggregate query with min
10) mysql - greatest n per group with a 3 tables join
11) mysql - Optimizing a query that gets the opening balance
12) mysql - Deleting all records on a table except the latest 10 for each user
13) mysql - Latest value of each GROUP with INNER JOIN
14) postgresql - Count rows with max per group and additional condition
15) postgresql - Find first-time purchases with certain category
16) postgresql - Postgresql get rows based on minimum value
17) postgresql - How to make DISTINCT ON faster in PostgreSQL?
18) postgresql - How to SELECT "closest" rows from another table?
19) sql-server - join two tables, include one row from the parent table for each primary key
20) postgresql - How to limit an inner query by outer query attribute
21) oracle - MIN(column) with subquery
22) postgresql - Slow left join lateral in subquery
23) mysql - Sort table by column with column ordered by earliest instance of another column
24) postgresql - Backfilling data using generate time series
25) mariadb - Variation on greatest-n-per-group where whole table is needed with indicator, not just greatest rows per group
26) mysql - Alternative to using MIN() in a subquery?
27) postgresql - SELECT DISTINCT ON, ordered by another column
28) postgresql - How to properly implement compound greatest-n filtering
29) mysql - Apply nth occurrence number on each distinct value in a column
30) mysql - Finding most recent entry per group running very slowly
31) sql-server - Is there a way to do the following query with joins instead of a sub query?
32) postgresql - PostgreSQL - maximum of sum over different months with ties over multiple years
33) postgresql - Get top two rows per group efficiently
34) postgresql - GROUP BY one column, while sorting by another in PostgreSQL
35) mariadb - Pick specific column value in a group of rows based on condition
36) mysql - Select ONE most recent post for each author
37) postgresql - How to get the second highest value per group?
38) sql-server - Select only the most recent record
39) mysql - MySql Query for Max(Date) not Today
40) postgresql - get only rows with max group value
41) sql-server - Get last two IDs from rows for last two days
42) postgresql - How to optimise request
43) mysql - Mysql Select recent 2 records for each group[user]
44) mysql - Possible to rewrite this query as a join?
45) postgresql - Get the last 5 distinct values for each ID
46) sql - Select first row in each GROUP BY group?
47) postgresql - Postgres Greatest Query not returning correct timestamp
48) mysql - Select maximum of a count in a grouped clause
49) postgresql - Getting an aggregate (here: min) for a group of values
50) sql-server - Get Single greatest date for each record