Question : I have these tables: DROP TABLE IF EXISTS books; CREATE TABLE `books` ( `bookId` mediumint(8) UNSIGNED NOT NULL, […]
Tag: sum
New field based on sum field
Question : I’m trying to create a new field based in another (sum field) SELECT sum(price) AS old_price, old_price+100 AS […]
In PHP MySQL how to sum or not sum multiple columns?
Question : I have three tables this is my codes: <table border=’1′> <tr> <th>Subject</th> <th>Mark1</th> <th>Mark2</th> <th>Mark3</th> <th>Sum Marks</th> </tr> […]
do a sum for each entry in table [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
Using GROUPing or ROLLUP rather than SUMing every column
Question : I am currently looking for a way to achieve what this query is doing without using SUM for […]
how can we merge sum and count? [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Get rows above and below a certain row, based on two criteria SQL (with SUM)
Question : Say I have a table like so: +———-+———+——+———————+ |student_no|level_id |points| timestamp | +———-+———+——+———————+ | 4 | 1 | […]
Query for getting the sum of all unique entries in a column
Question : Currently I’m using mysql to return the sum of all data in a column that have the same […]
SUM and JOIN 2 columns with different tables but it duplicates results
Question : SELECT DISTINCT [Transfer Shipment Line].[Transfer-to Code] AS [Loc Code] ,[Transfer Shipment Line].[Item No_] ,[Transfer Shipment Line].[Description] ,[Transfer Shipment […]
Summing a column based on uniqueness of another column without using temporary table
Question : I have a table like this: CREATE TABLE `files` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT […]