greatest-n-per-group

133 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
How to make LEFT JOIN with row having max date?
user_35307990
•
4
10
19379
greatest-n-per-group left-join group-by oracle sql
How to get single last record with a particular id in codeigniter
user_83183700
•
2
2
1121
greatest-n-per-group codeigniter mysql php
SQL Server: Select entry based on frequency of entries in another table
user_88591300
•
4
5
302
greatest-n-per-group select sql-server
Select one row, each one id in sql query for odoo
user_86379980
•
2
2
553
odoo-8 greatest-n-per-group postgresql sql
Select all where latest relation is true?
user_13177710
•
3
3
255
laravel greatest-n-per-group mysql sql php
select max value in each 5 rows
user_79558590
•
2
3
174
sql-server-2008-r2 greatest-n-per-group tsql sql-server
Why does SQL query with GROUP BY produce more rows?
user_3608400
•
4
3
2003
greatest-n-per-group mysql sql
Use something like TOP with GROUP BY
user_32064400
•
9
5
187
greatest-n-per-group aggregate postgresql sql
Delete duplicate rows but keep the earliest row (by date criteria) - SQL Server
user_39541460
•
3
4
4979
sql-delete greatest-n-per-group sql-server sql
Aggregating the most recent joined records per week
user_1276290
•
10
3
675
greatest-n-per-group postgresql sql
Hot Questions