greatest-n-per-group

133 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
How can I get the corresponding value of a column based on an aggregate of another column?
user_145062330
•
4
1
768
maxby snowflake-cloud-data-platform greatest-n-per-group sql
Laravel query Builder Select from subquery
user_105192170
•
1
1
2850
laravel-query-builder eloquent laravel greatest-n-per-group sql
In a table of timed observations from multiple sensors, how to optimally retrieve the last observation for each sensor
user_94231370
•
2
3
53
greatest-n-per-group postgresql sql
using FORCE INDEX to ensure the table is ordered with GROUP BY and ORDER BY before calculating user variables
user_137509150
•
2
2
60
greatest-n-per-group window-functions mysql
PostgreSQL. Select a column that correlates with value in the aggregate function
user_133670460
•
1
3
315
greatest-n-per-group random postgresql sql
SQL query with linear interpolation and Group By
user_42779480
•
3
1
434
presto lateral-join amazon-athena greatest-n-per-group sql
Trying to grab a column from 2 subqueries being joined and grouping not working
user_132186780
•
2
1
58
greatest-n-per-group inner-join count mysql sql
Calculate difference of multiple highest and lowest column values
user_138704640
•
2
4
274
greatest-n-per-group select postgresql sql
Postgres Conversion of ORacle KEEP DENSE_RANK FIRST
user_135342880
•
2
1
1455
greatest-n-per-group sql-update postgresql oracle sql
Find Nth value and average value corresponding to each group in SQL
user_37459490
•
4
2
390
aggregate-functions greatest-n-per-group postgresql average sql
Hot Questions