greatest-n-per-group

133 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
SQLite Running Total (but keyed on values in a different table)
user_49988650
•
1
1
95
greatest-n-per-group window-functions common-table-expression sqlite sql
Find object having the highest value in JSONB array of objects in Postgresql
user_36449610
•
1
2
111
jsonb greatest-n-per-group postgresql sql
Doctrine Query Language Latest Row Per Group
user_160027650
•
1
1
221
symfony doctrine greatest-n-per-group mysql php
Retrieving last record in each group from an external table with Azure Synapse Serverless Pool
user_88172850
•
1
2
290
azure-synapse greatest-n-per-group azure tsql
Get the first item of some group in a single SELECT
user_24463740
•
1
1
122
greatest-n-per-group postgresql sql
Effectively select latest row for each group in a very large table?
user_2193350
•
5
1
627
amazon-redshift greatest-n-per-group query-optimization sql
How to get the values for every group of the top 3 types
user_49952490
•
3
2
76
greatest-n-per-group aggregate postgresql sql
Postgres distinct query in two columns
user_143134510
•
1
2
49
greatest-n-per-group postgresql
How to display multiple items but only the highest values in year and month for each?
user_159846580
•
1
1
66
greatest-n-per-group mysql
Select the first row in the last group of consecutive rows
user_74922890
•
2
2
405
greatest-n-per-group postgresql sql
Hot Questions