I’ve got a table which contains event status data, similar to this: ID Time Status —— ————————– —— 357920 2019-12-25 09:31:38.854764 1 …
Tag: sum
Get comments per video and total sum of comments per video channel
In addition to Get total sum of video comments for each video I noticed that I can’t use v.commentCount because I cleaned some data and now the column is inaccurate. So I need to count the videoId comments and the total videoID comments with the comment table. I have a table video and a table comments. …
Subtract values from the same Column in sql? [closed]
Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers. This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers. Closed 2 y…
MySQL sum() from more than 1 table
Ok, so every sum() returns the desired value, I already checked it but I’m having problems when trying to sum everything together and then get the total value. Basically I have to do this: initial Fee(which is a set value defined on the”customer” table) + sum of activity1 cost + sum of activ…
is there anyway to display single column data into multiple columns
I tried to do it but it was impossible for me. the solution I need to display single column data into multiple column for the current table only. e.g column [status] 3 records {present,late,absent} to display 3 columns and single row, to prevent 3 rows The result i want to display like this by grouping tid Ta…
SUM function consider NULL on Oracle 12c
I was trying to get the nulls on doing a SUM() function on sql and I figured out that sql now consider nulls, so if a column has a different value and a null value the sum is good calculated. For …
MS-Access Query to PostgreSQL View
I am converting a microsoft access query into a postgresql view. The query has obvious components that I have found reasonable answers to. However, I am still stuck on getting the final result: …
Get query result 15 second interval in Oracle
I have following query to get 15 seconds interval. However I want to show also ‘0’ values even if the result doesn’t have value. Here is the Query; select to_char(trunc(sample_time,’hh24′) + (trunc(…
SQL: How to group by with two tables?
I have the tables products and history and I need to group by name: products = (id_product, name) history = (id_history, id_product, amount) I tried this SQL query but it isn’t grouped by name: …
SQL SUM on multiple INNER JOIN
I am trying to get the sum of particular fields through multiple table using joins. I am getting the SUM wrong when I I try to get the values together. I have table State as I have another table Balance as I have one more table Loan as What I want as a result from my query is, When I