SQL Server Aggregate functions -

-

i have table has 3 columns: customers, billingdate, consumption

city - parks/6th ave bmx park   2013-04-29 00:00:00.000 0 city - parks/6th ave bmx park   2013-04-29 00:00:00.000 30 city - parks/6th ave bmx park   2013-05-30 00:00:00.000 0 city - parks/6th ave bmx park   2013-05-30 00:00:00.000 19500 city - parks/6th ave bmx park   2013-06-28 00:00:00.000 0 city - parks/6th ave bmx park   2013-06-28 00:00:00.000 42100 city - fire station #3  2012-11-27 00:00:00.000 0 city - fire station #3  2012-11-27 00:00:00.000 8900 city - fire station #3  2012-12-27 00:00:00.000 0 city - fire station #3  2012-12-27 00:00:00.000 7900 city - fire station #3  2013-01-28 00:00:00.000 0 city - fire station #3  2013-01-28 00:00:00.000 3090 city - fire station #3  2013-01-28 00:00:00.000 7210 city - fire station #3  2013-02-28 00:00:00.000 0 city - fire station #3  2013-02-28 00:00:00.000 10100 city - fire station #3  2013-03-29 00:00:00.000 0 city - fire station #3  2013-03-29 00:00:00.000 6700 city - fire station #3  2013-04-29 00:00:00.000 0 city - fire station #3  2013-04-29 00:00:00.000 9100 city - fire station #3  2013-05-30 00:00:00.000 0 city - fire station #3  2013-05-30 00:00:00.000 11100 city - fire station #3  2013-06-28 00:00:00.000 0 city - fire station #3  2013-06-28 00:00:00.000 12700 city - fire station #3  2012-07-27 00:00:00.000 0 city - fire station #3  2012-08-27 00:00:00.000 0 city - fire station #3  2012-08-27 00:00:00.000 1630 city - fire station #3  2012-09-28 00:00:00.000 0

since have same billingdate same customer, want sum consuption based on matching billingdate. should give me following:

city - parks/6th ave bmx park   2013-04-29 00:00:00.000 30 city - parks/6th ave bmx park   2013-05-30 00:00:00.000 19500 city - parks/6th ave bmx park   2013-06-28 00:00:00.000 42100 city - fire station #3  2012-11-27 00:00:00.000 8900

and on....

i posted similar question did not looking for. thank sql experts.

if haven't missed something

select customers, billingdate, sum(consumption) table1 group customers, billingdate

Comments

Post a Comment

Popular posts from this blog

Issues changing the value of an element in an array in matlab -

-
i'm trying create program sum n-1 , n-2 numbers create n , store value in array. currently, output (assuming numdisp > 2 ) num1 , num2 , 0 , 0 , 0 ... size of array correct, i'm having issues reassigning elements. num1 = input('input first integer of fibonacci sequence: '); num2 = input('input second integer of fibonacci sequence: '); numsdisp = input('how many integers display? --> '); list = zeros(numsdisp,1); list(1) = num1; list(2) = num2; if (numsdisp <=0) disp('value must integer greater zero.') elseif (numsdisp == 1) disp(num1) elseif (numsdisp == 2) disp(num1) disp(num2) else disp(num1) disp(num2) index = 3:numsdisp disp(list(index)) list(index) = list((index-1)) + list((index-2)); end end example input: 3 3 4 corresponding output: 3 3 0 0 you aren't printing out final result, intermediate steps. in for loop, printing list(index) updating value, rather updat...
Read more

vb.net - Alternative to the T-SQL AS keyword -

-
please see code below: imports system.data.sqlclient imports system.configuration public class form1 private _constring string private sub form1_load(byval sender object, byval e system.eventargs) handles me.load dim objdr sqldatareader dim objcommand sqlcommand dim objcon sqlconnection dim id integer try _constring = configurationmanager.connectionstrings("testconnection").tostring objcon = new sqlconnection(_constring) objcommand = new sqlcommand("select person.urn, car.urn person inner join car on person.urn = car.urn , personid=1") objcommand.connection = objcon objcon.open() objdr = objcommand.executereader(connectionstate.closed) while objdr.read id = objdr("urn") 'line 19 loop objdr.close() ...
Read more

php - MySQLi binding parameters in a prepared statement doesn't work unless inserted after "WHERE" -

-
i have php code pulls info database. uses prepared statement, works fine written below: <?php $n = '5'; if ($stmt = $connection->prepare("select title items id = ?")) { $stmt->bind_param("s", $n); $stmt->execute(); $stmt->bind_result($title); while ($stmt->fetch()) { echo $title; } $stmt->close(); } ?> and let's echo "batman". however, when move placeholder here: "select ? items id = 5" and change: $n = 'title'; instead of echoing "batman", echoes "title". not possible use placeholder select parameter? what have done this: select "title" items id = 5 you cant use prepared statement bindings identifiers, parameters.
Read more