greatest-n-per-group

133 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
Find the 3rd top selling item postgres
user_43067100
•
1
2
49
greatest-n-per-group postgresql sql
Why can't I use this code to select the max row
user_196235400
•
1
3
53
greatest-n-per-group mysql sql
Create a repost of latest and second latest value
user_93198110
•
1
4
42
greatest-n-per-group sql
Is it wasteful to use ARRAY_AGG to get the first non-NULL value in a column?
user_917570
•
1
3
52
array-agg postgresql-performance greatest-n-per-group postgresql sql
Count events with a cool-down period after each instance
user_62373390
•
4
2
109
time-series gaps-and-islands greatest-n-per-group postgresql sql
Get minimum price from last 30 days and the last price before that, quickly
user_55800860
•
2
2
131
postgresql-performance timescaledb greatest-n-per-group postgresql sql
Window function with same result in subgroup
user_81582130
•
1
1
36
greatest-n-per-group window-functions postgresql sql
Find day of week with most hires
user_136456060
•
1
3
98
greatest-n-per-group having max oracle sql
Getting top 3 rows for each ID in a list
user_46892060
•
2
3
94
greatest-n-per-group postgresql sql
SQL exclude rows containing nearly duplicate values filtered by grouped max values
user_147953110
•
2
2
78
greatest-n-per-group tsql sql-server sql
Hot Questions