greatest-n-per-group

133 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
Select newest entry for each user without using group by (postgres)
user_95529820
•
2
2
91
greatest-n-per-group sql-order-by datetime postgresql sql
Select max for a tuple in table
user_12647030
•
2
2
101
subquery greatest-n-per-group max sqlite sql
SQL Server Query Last Moved Item
user_79835990
•
2
1
42
greatest-n-per-group where-clause sql-server sql database
Laravel select unique products with lowest price from one table
user_135120750
•
2
1
504
laravel-query-builder laravel greatest-n-per-group mysql database
Performing `top_n`-like operations on tibbles with intersecting groups
user_29701960
•
3
2
74
tibble dplyr greatest-n-per-group grouping r
How can I return the most recent rows at or before $TIMESTAMP at a certain time zone, via a Postgres 11 function (stored proc)?
user_97422750
•
2
1
106
timestamp-with-timezone greatest-n-per-group date postgresql sql
How to "Roll-Up" data across multiple columns and rows
user_8623690
•
2
2
106
sql-server-2012 greatest-n-per-group tsql sql-server sql
What is the best SQL effective dates design pattern
user_121911050
•
2
1
84
lateral-join greatest-n-per-group left-join sql-server sql
MySQL GROUP BY on Virtual Column with ORDER BY
user_4701590
•
2
2
588
mysql-5.7 greatest-n-per-group group-by sql-order-by mysql
How to retriever the First Record and Last Record in the Group, for Same Date, In Oracle SQL
user_72534210
•
2
1
32
greatest-n-per-group oracle10g date oracle sql
Hot Questions