Question

Limit number of rows per group from join (NOT to 1 row)

score 3.6k · Answer 1 · 2015-06-10 22:06:43

3.6k

Views

Limit number of rows per group from join (NOT to 1 row)

Published on 10 June 2015 at 22:06

score 7.2k · Answer 2 · 2015-06-11 01:19:38

7.2k

Views

dplyr: max value in a group, excluding the value in each row?

Published on 11 June 2015 at 01:19

score 2k · Answer 3 · 2015-06-16 20:50:30

2k

Views

How to group following rows by not unique value

Published on 16 June 2015 at 20:50

score 6.6k · Answer 4 · 2015-06-16 13:09:09

6.6k

Views

PostgreSQL get latest rows/events for all users

Published on 16 June 2015 at 13:09

score 8.6k · Answer 5 · 2015-06-19 18:28:46

8.6k

Views

Select first row from group each by with count using Big Query

Published on 19 June 2015 at 18:28

score 135 · Answer 6 · 2015-06-24 21:19:57

135

Views

Select all records of type 'x' that are the highest 'version'

Published on 24 June 2015 at 21:19

score 111 · Answer 7 · 2015-06-25 16:25:19

111

Views

MYSQL - FInd last date and group by IDUSER

Published on 25 June 2015 at 16:25

score 70 · Answer 8 · 2016-12-14 16:06:27

70

Views

MySQL: Grouping and counting multiple occurences, then only display the highest amount per individual combination

Published on 14 December 2016 at 16:06

score 115 · Answer 9 · 2016-12-13 00:02:04

115

Views

SQL: Select Rows with Max Value of One Colume For Each Value

Published on 13 December 2016 at 00:02

score 603 · Answer 10 · 2016-12-19 07:44:26

603

Views

Filtering rows to get only the latest value

Published on 19 December 2016 at 07:44

score 70 · Answer 11 · 2016-12-17 23:39:56

70

Views

Restricting a SQL query so that any particular value in a certain column can only appear 3 times in the results, with respect to a given ordering

Published on 17 December 2016 at 23:39

score 131 · Answer 12 · 2016-12-20 02:29:16

131

Views

SQL correlated subquery sequence of events

Published on 20 December 2016 at 02:29

score 2.1k · Answer 13 · 2016-12-21 16:19:06

2.1k

Views

JOIN table with itself using JPA Criteria API (or otherwise solve greatest-n-per-group)

Published on 21 December 2016 at 16:19

score 85 · Answer 14 · 2016-12-22 08:36:46

85

Views

Get student that has the highest number of A's

Published on 22 December 2016 at 08:36

score 51 · Answer 15 · 2016-12-20 06:51:14

51

Views

Find top 2 cities visitor goes

Published on 20 December 2016 at 06:51

score 47 · Answer 16 · 2016-12-27 18:10:12

47

Views

My SQL with MAX Function and then grouping & summing values and text

Published on 27 December 2016 at 18:10

score 283 · Answer 17 · 2016-12-23 11:31:34

283

Views

Select the top points of each category in SQLite

Published on 23 December 2016 at 11:31

score 19 · Answer 18 · 2016-12-30 10:09:06

19

Views

Select N rows grouped by foreign key

Published on 30 December 2016 at 10:09

score 1.8k · Answer 19 · 2016-12-30 11:06:52

1.8k

Views

How to SELECT other fields from the row with the MAX value

Published on 30 December 2016 at 11:06

score 514 · Answer 20 · 2016-12-31 15:56:49

514

Views

MySQL select max record from each group and insert into another table

Published on 31 December 2016 at 15:56

List Question

Limit number of rows per group from join (NOT to 1 row)

dplyr: max value in a group, excluding the value in each row?

How to group following rows by not unique value

PostgreSQL get latest rows/events for all users

Select first row from group each by with count using Big Query

Select all records of type 'x' that are the highest 'version'

MYSQL - FInd last date and group by IDUSER

MySQL: Grouping and counting multiple occurences, then only display the highest amount per individual combination

SQL: Select Rows with Max Value of One Colume For Each Value

Filtering rows to get only the latest value

Restricting a SQL query so that any particular value in a certain column can only appear 3 times in the results, with respect to a given ordering

SQL correlated subquery sequence of events

JOIN table with itself using JPA Criteria API (or otherwise solve greatest-n-per-group)

Get student that has the highest number of A's

Find top 2 cities visitor goes

My SQL with MAX Function and then grouping & summing values and text

Select the top points of each category in SQLite

Select N rows grouped by foreign key

How to SELECT other fields from the row with the MAX value

MySQL select max record from each group and insert into another table

Trending Questions

Popular # Hahtags

Popular Questions