Questions tagged [group-by]

19

votes

2

answers

Count totals by year and month

asked 2011-03-02T10:45:50.740

26

votes

9

answers

SQL - Displaying entries that are the max of a count?

sql group-by

asked 2011-03-01T20:26:36.573

54

votes

10

answers

MySQL Order before Group by

mysql wordpress group-by sql-order-by

asked 2011-02-28T10:28:35.300

20

votes

1

answers

Oracle / SQL - Count number of occurrences of values in a single column

sql oracle-database group-by aggregate-functions

asked 2011-01-18T22:32:54.977

13

votes

4

answers

Is the GROUP BY clause in SQL redundant?

sql group-by

asked 2010-12-22T01:12:00.147

24

votes

5

answers

mysql group by and sort each group

mysql sql sorting group-by

asked 2010-12-15T09:37:35.923

9

votes

4

answers

MySQL: How does groupby work on columns without aggregate functions?

mysql group-by

asked 2010-11-14T17:57:04.167

21

votes

4

answers

Last 12 months, group by week

group-by

asked 2010-09-24T15:11:28.850

11

votes

4

answers

return count 0 with mysql group by

sql mysql count group-by

asked 2010-08-30T02:53:52.060

9

votes

3

answers

Group DateTime by an arbitrary time interval

c# linq group-by

asked 2010-08-24T17:39:30.077

82

votes

3

answers

Using GroupBy, Count and Sum in LINQ Lambda Expressions

linq count lambda group-by sum

asked 2010-08-05T11:09:27.373

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

13

votes

3

answers

Which is faster: JOIN with GROUP BY or a Subquery?

sql-server sql-server-2008 join group-by subquery

asked 2010-07-01T08:23:24.290

55

votes

10

answers

Group mysql query by 15 min intervals

mysql sql datetime group-by timestamp

asked 2010-05-08T12:13:02.297

23

votes

4

answers

Why do I need to explicitly specify all columns in a SQL "GROUP BY" clause - why not "GROUP BY *"?

group-by aggregate ansi-sql sql

asked 2010-05-05T22:33:14.723

14

votes

1

answers

What are the Ruby equivalent of Python itertools, esp. combinations/permutations/groupby?

ruby combinations group-by permutation python-itertools

asked 2010-03-14T18:32:47.703

37

votes

11

answers

Android: Distinct and GroupBy in ContentResolver

android distinct group-by android-contentresolver

asked 2010-02-22T23:54:15.777

10

votes

1

answers

How do I count occurrences by day in SQL?

sql sql-server t-sql group-by

asked 2010-01-24T18:56:02.920

176

votes

2

answers

Linq with group by having count

linq count group-by having

asked 2010-01-16T19:59:12.190

12

votes

2

answers

XSLT 1.0 Group By

xml xslt group-by

asked 2009-12-14T22:17:32.713

76

votes

1

answers

LINQ Group By Multiple fields -Syntax help

c# linq group-by

asked 2009-12-08T18:40:03.273

310

votes

8

answers

Is it possible to GROUP BY multiple columns using MySQL?

mysql sql group-by

asked 2009-12-03T17:13:40.930

26

votes

5

answers

How to count group by rows in rails?

ruby-on-rails ruby group-by count

asked 2009-10-30T03:42:16.530

85

votes

3

answers

ILookup<TKey, TVal> vs. IGrouping<TKey, TVal>

c# linq group-by igrouping ilookup

asked 2009-08-26T21:16:31.727

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

71

votes

5

answers

SQL GROUP BY CASE statement with aggregate function

sql sql-server sql-server-2005 group-by

asked 2009-07-30T19:38:28.930

123

votes

8

answers

MySQL "Group By" and "Order By"

mysql sql group-by sql-order-by aggregate-functions

asked 2009-06-30T22:40:38.463

10

votes

5

answers

Concat groups in SQL Server

sql sql-server group-by string-concatenation

asked 2009-06-02T18:22:13.163

52

votes

6

answers

mysql select sum group by date

mysql select group-by

asked 2009-06-02T02:13:00.593

51

votes

5

answers

LINQ: Group by month and year within a datetime field

linq t-sql group-by substring

asked 2009-04-18T04:35:41.617

529

votes

13

answers

How to query as GROUP BY in Django?

python django django-models group-by

asked 2009-03-10T10:10:30.390

67

votes

9

answers

MySQL - Control which row is returned by a group by

mysql sql-order-by group-by

asked 2009-02-11T15:06:39.887

39

votes

5

answers

sql group by versus distinct

mysql sql-server performance group-by distinct

asked 2009-01-09T01:22:30.583

37

votes

4

answers

C# List<> GroupBy 2 Values

c# linq list ienumerable group-by

asked 2008-12-12T18:10:25.250

77

votes

14

answers

How do I return my records grouped by NULL and NOT NULL?

sql null group-by

asked 2008-10-27T10:48:48.737

501

votes

15

answers

How to concatenate strings of a string field in a PostgreSQL 'group by' query?

sql postgresql group-by string-aggregation

asked 2008-09-04T14:27:16.263

Questions tagged group-by