7 Answered Questions

[SOLVED] Grouping or Window

6 Answered Questions

[SOLVED] Select columns inside json_agg

2 Answered Questions

[SOLVED] Why do wildcards in GROUP BY statements not work?

3 Answered Questions

[SOLVED] Use column alias in GROUP BY

1 Answered Questions

[SOLVED] WITH ROLLUP WHERE x IS NULL

3 Answered Questions

[SOLVED] Finding contiguous ranges in grouped data

2 Answered Questions

[SOLVED] PostgreSQL: Generate a series of dates for each group in a table

  • 2016-03-25 20:48:31
  • Shaun Scovil
  • 5339 View
  • 7 Score
  • 2 Answer
  • Tags:   postgresql group-by

4 Answered Questions

[SOLVED] Group data by non-unique keys by distinct time range

3 Answered Questions

[SOLVED] Stop SQL Server from ordering results?

4 Answered Questions

1 Answered Questions

[SOLVED] Why am I getting different results from a query vs. a view

3 Answered Questions

[SOLVED] Full Outer Join shows NULL when Group By is used

6 Answered Questions

[SOLVED] Find "n" consecutive free numbers from table

2 Answered Questions

6 Answered Questions

[SOLVED] Why do we use Group by 1 and Group by 1,2,3 in SQL query?

2 Answered Questions

[SOLVED] Postgres: Use result of group by as column names

1 Answered Questions

[SOLVED] Multiple "GROUP_CONCAT"s with WHERE clause

1 Answered Questions

[SOLVED] Does the SQL Spec require a GROUP BY in EXISTS ()

5 Answered Questions

[SOLVED] Get only overall summary WITH ROLLUP and GROUP BY for multiple fields

  • 2014-06-19 22:22:56
  • yoshi
  • 21113 View
  • 7 Score
  • 5 Answer
  • Tags:   mysql group-by

4 Answered Questions

[SOLVED] SQL Challenge - The Sensor Threshold Exception Report

1 Answered Questions

[SOLVED] Group by NAME and YEAR, categorize NAME

3 Answered Questions

[SOLVED] Pivot, categorize and group by

3 Answered Questions

[SOLVED] Select rows based on latest date with multiple joins

  • 2014-01-12 17:20:47
  • stiq
  • 41748 View
  • 8 Score
  • 3 Answer
  • Tags:   mysql group-by

2 Answered Questions

[SOLVED] Query to get queue position for each group

2 Answered Questions

[SOLVED] SQL Server: Order of Rows

2 Answered Questions

2 Answered Questions

[SOLVED] GROUP BY two columns

2 Answered Questions

[SOLVED] How do I use window functions ("over") together with crosstab in Postgres?