greatest-n-per-group

133 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
SQL query to select up to N records per criteria
user_83347240
•
2
2
567
snowflake-cloud-data-platform greatest-n-per-group window-functions select sql
How do I build a query in Ruby on Rails that joins on the max of a has_many relation only and includes a select filter on that relation?
user_12182800
•
3
7
1234
greatest-n-per-group postgresql ruby-on-rails ruby
select greatest element per group in querydsl
user_36886480
•
3
2
1724
querydsl greatest-n-per-group jpa sql java
How to get top n results per group from a pool of ids in SQLAlchemy?
user_106342060
•
2
1
2009
greatest-n-per-group sqlalchemy postgresql python
PostgreSQL - Show the last N rows for each sorted group
user_1787280
•
3
1
1351
greatest-n-per-group group-by postgresql sql
Find max value from column that has a json object with key-value pairs
user_102310560
•
2
2
1284
presto greatest-n-per-group tsql sql json
sql How to select most popular item for each state
user_117020750
•
2
1
1025
greatest-n-per-group group-by postgresql
Get permissions for a given user
user_19287510
•
3
1
138
aggregate-functions greatest-n-per-group mysql sql
SQL: Greatest row with variable group / condition
user_41730900
•
2
2
92
greatest-n-per-group db2 select group-by sql
mysql query to retrieve first 2 records for each item type
user_43027910
•
3
5
836
mariadb greatest-n-per-group sql
Hot Questions