Alex Rivera | Logout

Questions tagged greatest-n-per-group

24 questions

Sort by: Newest Votes Active
12
votes
7
answers

Select the top 1 row from each group

sql sql-server-2012 group-by greatest-n-per-group
asked 2013-03-13T08:56:01.007
98
votes
8
answers

Select a Column in SQL not in Group By

sql sql-server-2008 t-sql greatest-n-per-group
asked 2012-08-16T15:54:38.413
8
votes
6
answers

SQL - selecting all rows with maximum value

mysql sql greatest-n-per-group
asked 2012-07-08T08:13:28.137
11
votes
5
answers

MySQL return first row of a joined table

php mysql sql join greatest-n-per-group
asked 2012-03-04T21:52:21.143
42
votes
7
answers

Selecting most recent and specific version in each group of records, for multiple groups

sql sql-server t-sql greatest-n-per-group
asked 2012-02-24T12:25:31.980
123
votes
7
answers

Get most recent row for given ID

mysql sql greatest-n-per-group
asked 2011-12-15T16:30:13.683
24
votes
4
answers

MySQL Left Join + Min

mysql group-by left-join greatest-n-per-group min
asked 2011-09-28T18:58:21.213
10
votes
2
answers

Order within group by?

mysql greatest-n-per-group
asked 2011-08-29T17:46:00.477
14
votes
1
answers

Nested Select statement in MYSQL join

mysql join nested greatest-n-per-group
asked 2011-08-25T17:21:57.960
20
votes
7
answers

Trying to find the second largest value in a column (postgres sql)

sql postgresql greatest-n-per-group
asked 2011-02-06T01:33:08.237
61
votes
8
answers

T-SQL: Selecting Column Based on MAX(Other Column)

sql sql-server t-sql greatest-n-per-group
asked 2010-09-09T20:19:23.883
19
votes
2
answers

SQL server select distinct rows using most recent value only

sql sql-server sql-server-2005 t-sql greatest-n-per-group
asked 2010-08-09T18:22:37.653
14
votes
3
answers

Retrieving the most recent records within a query

sql-server sql-server-2005 t-sql group-by greatest-n-per-group
asked 2010-07-05T22:17:19.853
9
votes
4
answers

How to Select only one unique record from the Table using Distinct

oracle-database distinct greatest-n-per-group
asked 2010-06-25T09:37:49.207
396
votes
25
answers

how do I query sql for a latest record date for each user

sql greatest-n-per-group
asked 2010-03-09T18:35:38.167
548
votes
14
answers

Restrict results to top N rows per group

sql mysql greatest-n-per-group ranking
asked 2010-01-25T01:25:02.777
10
votes
3
answers

How can a do a "greatest-n-per-group" query in django?

sql django join greatest-n-per-group
asked 2010-01-21T17:57:51.563
342
votes
23
answers

ROW_NUMBER() in MySQL

mysql sql greatest-n-per-group rank row-number
asked 2009-12-12T23:58:44.780
39
votes
8
answers

How to SELECT the newest four items per category?

sql mysql greatest-n-per-group
asked 2009-09-18T03:59:31.270
1363
votes
34
answers

Retrieving the last record in each group - MySQL

mysql sql group-by greatest-n-per-group groupwise-maximum
asked 2009-08-21T17:04:04.147
14
votes
2
answers

Selecting all corresponding fields using MAX and GROUP BY

sql mysql group-by max greatest-n-per-group
asked 2009-08-20T09:38:41.123
920
votes
22
answers

How can I SELECT rows with MAX(Column value), PARTITION by another column in MYSQL?

mysql sql max distinct greatest-n-per-group
asked 2009-03-04T20:14:26.573
51
votes
7
answers

How do I join the most recent row in one table to another table?

sql date join greatest-n-per-group
asked 2009-01-30T22:31:34.940
34
votes
9
answers

Get most common value for each value of another column in SQL

sql postgresql greatest-n-per-group
asked 2008-12-05T17:58:10.857