Tag: group-by

Found 254 results for 'group-by'.

1) sql-server - SQL join query to show rows with non-existent rows in one table
2) postgresql - GROUP BY after ORDER BY/LIMIT/OFFSEt?
3) mysql - Need to find the employees who have switched jobs atleast twice
4) query - Group json data in db using a query
5) azure-sql-database - Column 'Comments.Text' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause
6) postgresql - How to unnest and GROUP BY elements of a JSON array?
7) postgresql - Slow query on large table with GROUP BY and ORDER BY
8) postgresql - Improve performance of COUNT/GROUP-BY in large PostgresSQL table?
9) postgresql - Distinct on two columns, how to rid from 'duplicates'
10) mysql - Latest value of each GROUP with INNER JOIN
11) mysql - Full outer join in MySql
12) postgresql - Count rows with max per group and additional condition
13) mysql - Help for grouping a field and taking total sum
14) oracle - Query with group by having count 0
15) oracle - SQL queries to get the duplicate records based on trim
16) mysql - Do id columns help (in speed) select statements?
17) t-sql - Union from Multiple Tables in many databases and group results in batches of n
18) sql-server - How to bring data from two tables that could/could not be present in one of them
19) mysql - How to optimize a very slow query with joins and group by?
20) mysql - mysql: counting number of tickets which are open per day basis
21) mysql - MYSQL: How to select all attributes of all duplicate entries?
22) postgresql - Postgresql Update Table row values by Grouped Column
23) mysql - UPDATE a table by self JOIN and GROUP BY
24) postgresql - Group by with a break on date
25) mysql - Median with GROUP BY
26) sql-server - Group by multiple columns, agregate others and select all in SQL Server
27) postgresql - Enforce known functional dependency in a group by clause
28) mysql - How to group same columns from same two tables, but from two different result sets and/or conditions
29) postgresql - PostgreSQL: Generate a series of dates for each group in a table
30) oracle - GROUP BY with weighted average
31) mysql - Need to find the number of employee who are not in all department
32) mysql - How do I solve this problem of a correlated subquery
33) mysql - MySQL code to show specific rows based on another...?
34) group-by - How to enforce strict handling of GROUP BY with non-aggregate / bare columns or UPDATE with multiple-row SELECT in SQLite
35) mysql - Sub Query with group by returns more than 1 row Issue
36) mysql - Alternative to using MIN() in a subquery?
37) mysql - Optimizing Queries HAVING COUNT and INSERT...ON DUPLICATE KEY UPDATE
38) group-by - SQL query to get the user, counting the minimum number of records
39) mysql - How to join with null value?
40) postgresql - Find missing timestamps grouped by key: finding gaps in my data
41) mysql - Finding contiguous ranges in grouped data
42) mysql - Performing SQL counts with and without a WHERE clause from the same table
43) mysql - MySQL Grouping Order
44) mysql - How to group by continuous days in mysql
45) sql-server - Help needed with SQL Server query: Accessing columns not in GROUP BY clause
46) primary-key - How to include in the result of a `SELECT ... GROUP BY ...` all the other columns that are functionally dependent on the grouping ones?
47) postgresql - How to transpose values from one column into columns with a value from a different column?
48) mysql - Filtering subquery results with group by
49) oracle - oracle sql: How to not select select duplicate records from table
50) sql-server - Using case and group by in select statement not working