Professional Web Applications Themes

sum value in a week - MySQL

Hi all, I have a table with this value data | value 2007-01-02 | 10 2007-01-05 | 5 2007-01-08 | 10 2007-01-10 | 10 2007-01-12 | 2 2007-01-14 | 3 [...] I need to obtain the sum(value) for all the week like: week from 2007-01-02 to 2007-01-08 sum 25 week from 2007-01-09 to 2007-01-15 sum 15 and so on... somebody can help me? thank you so much =^_^=...

  1. #1

    Default sum value in a week

    Hi all,
    I have a table with this value

    data | value
    2007-01-02 | 10
    2007-01-05 | 5
    2007-01-08 | 10
    2007-01-10 | 10
    2007-01-12 | 2
    2007-01-14 | 3
    [...]

    I need to obtain the sum(value) for all the week like:
    week from 2007-01-02 to 2007-01-08 sum 25
    week from 2007-01-09 to 2007-01-15 sum 15
    and so on...

    somebody can help me?
    thank you so much

    =^_^=

    Mic Guest

  2. #2

    Default Re: sum value in a week

    On Apr 24, 8:11 am, Mic <com> wrote: 


    SELECT SUM(value)
    FROM table
    GROUP BY week(date)

    ?

    strawberry Guest

  3. #3

    Default Re: sum value in a week



    thank you so much

    Mic Guest

  4. #4

    Default Re: sum value in a week

    == Quote from Mic (com)'s article 

    i think you can do something like this:
    select data, sum(value) from table group by week(data);

    that's all.
    lark Guest

Similar Threads

  1. Tip of the week
    By jnosal3 in forum Macromedia Contribute Connection Administrtion
    Replies: 5
    Last Post: January 18th, 12:49 AM
  2. D-day next week!
    By Dee Holmes in forum Adobe Illustrator Macintosh
    Replies: 37
    Last Post: June 10th, 05:10 PM
  3. how to get first day of the week
    By Dario Volaric in forum Macromedia Director Basics
    Replies: 2
    Last Post: February 16th, 01:18 PM
  4. Replies: 3
    Last Post: December 22nd, 10:42 PM
  5. This week's work!
    By Ray in forum Adobe Photoshop Elements
    Replies: 6
    Last Post: August 2nd, 09:45 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139