Question : This question already has answers here: MySQL – maximum of sum over different months with ties over multiple […]
Tag: sum
sum with combination
Question : I reproduce the table in image and result I expect. So, I like sum for each item withe […]
Need to sum a field in a row with same it and result needs to be cumulative in a field
Question : This is my SQL Server 2008 R2 table: ID Amount date_time 001 9.00 01/01/2015 01:01:00 001 20.00 01/02/2015 […]
Complex join 3 tables with sum and group by
Question : I’m trying to generate a report for one of our departments that pulls data from 3 tables. The […]
Join tables and summarize rows based on condition
Question : I have two tables. One containing countries with an ID and the geometry The other containing customers with […]
How to calculate the sums of two columns, when that two columns brought by join queries?
Question : I ran two queries as shown bellow; query 1: queried with JobRequiredProducts table and Product table to list […]
MySQL: SUM() returns multiple rows when used with joins and grouping
Question : I expected by query, which uses SUM() to return one row, containing the total of all rows. However, […]
Sum between multiple joined tables
Question : I have these tables: DROP TABLE IF EXISTS books; CREATE TABLE `books` ( `bookId` mediumint(8) UNSIGNED NOT NULL, […]
Calculate running total of “consecutive days without views” for each group, that can restart multiple times within each group based on conditions
Question : Summary I’m working to create a counter metric that shows, for each client’s slug, the number of consecutive […]
Distinct 3 columns and 4th column with sum [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]