sum

I'm having a problem with summing floats properly from my SQLite database. I have created my table as follows where I have set the column 'amount'…

I have this MySql query: SELECT YEAR(date), MONTHNAME(date), SUM(block_time) FROM flights WHERE operator = 'PSD' GROUP BY YEAR(date), MONTH(date)…

I have 3 mysql tables: Client_courses Client_courses_id Client_id Course_id 1 1 2 2 1 3 3 2 1 Client Client_id Name 1 Tom 2 John Courses Course_id…

I'm working on developing a basic search engine in MySQL. the search is based on keywords, and each searchable item has a number of keywords…

I have a table: id, cust#, payment, date 1, cus1, 508, 2010-01-01 2, cus2, 40, 2010-01-01 3, cus1, 13, 2010-01-02 I have this for my query. select…

If I have a map function emitting a timestamp as key ad a number as document, how to get sum of values selecting a date range?

Hi, This is my first post in this forum. I normally find ans to my problems when search but this is the first time I needed to post this question.…

I use the sum() function for provision in my mysql database, in this case query fetches only 1 result, it is 29.9 So sum(provision) is 29.8 I dont…

Im trying to make a a query, but its doubling the Sum values SELECT cidades.id AS id, cidades.name AS municipio, Sum(conjuntos.n_uhs) AS uh,…

İ have a video table named videos and here these are the columns : vid v_uid v_view v_title v_info 1 45 56487 foo foo 2 45 455 3 45 98989 ... My…

I have this query, a table transaction with value1, value2, and other columns var result = (from t in db.Transaction group t by t.TransactionId into…

SELECT promotions.`sms_promo_id`, places.`id`, places.`name`, insights.`checkins`, insights.`likes`, insights.`place_id` FROM promotions INNER JOIN…

I have three tables - players, round_one and round_two. In my query, I have SUM functions for pulling out point totals from round_one and round_two,…

Hi All, I am building a query in mysql 5.0 to calculate a student semester grade. The initial table (studentItemGrades) contains the list of…

I have these three tables: Products ID NAME 1 Notebook 2 Keyboard Base1 PRODUCT_ID PRICE 1 2 1 2 1 2 2 3 Base2 PRODUCT_ID PRICE 1 2 1 2 1 2 1 2 2 3…

Hey guys, I need some help with this. I have a table with about 100k records. Each row is referenced by an ID. Here is an example Keyword | Domain |…

I have searched for hours about this on google, stackoverflow, etc., and have found nothing. I would greatly appreciate any help! I have a mysql…

So I got a question about LEFT JOIN , this code returns different values for totalPoints depending on if the user got the group or not. (if user…

Hi!I have 3 tables in my mysql DB to query. Users_rates (fields: id,userid,raterid,rate,eventid) containing all of the rates(rate) that have been…

Hi. This should be really easy. Believe me, I've been researching this for hours. My query: SELECT not_piece.pid, part.name AS 'Part Name',…