greatest-n-per-group

133 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
How to get the latest message in each conversation of a certain user in SQL?
user_19080360
•
4
5
1845
greatest-n-per-group postgresql sql
Find max per group and return another column
user_14888580
•
7
4
5690
greatest-n-per-group r matrix
Select a Column in SQL not in Group By
user_16037340
•
86
7
185027
greatest-n-per-group sql-server-2008 tsql sql
Get top 1 row of each group
user_7246890
•
712
19
858311
greatest-n-per-group sql-server-2005 tsql sql-server sql
Select first row in each GROUP BY group?
David_Wolever_715220
•
1826
20
1568705
greatest-n-per-group group-by postgresql sqlite sql
COUNT results from SQL Query with a HAVING clause
user_3432910
•
13
4
23951
greatest-n-per-group count sql-server sql
T-SQL: Selecting Column Based on MAX(Other Column)
John_300060
•
53
7
92932
greatest-n-per-group tsql sql-server sql
GROUP BY with MAX(DATE)
user_4092220
•
204
6
452203
ora-00979 greatest-n-per-group group-by oracle sql
SQL server select distinct rows using most recent value only
Chris_349420
•
19
2
37501
greatest-n-per-group sql-server-2005 tsql sql-server sql
How do I limit a LEFT JOIN to the 1st result in SQL Server?
user_3080790
•
24
8
52527
greatest-n-per-group sql-server-2000 sql-server sql
Hot Questions