Professional Web Applications Themes

To query SUM of multiple row of the same key id - MySQL

Hi, Pls help What query I should use to get the SUM of this example EjenID ProductID Amount Month 1 41 2 9 2 40 2 9 1 40 3 9 2 41 2 9 1 42 2 10 how can I get the result of this: to view the EjenID total Amount of purchase in Month=9 look like this EjenID Amount Month 1 5 9 2 4 9 thanx...

Sponsored Links
  1. #1

    Default To query SUM of multiple row of the same key id

    Hi,

    Pls help

    What query I should use to get the SUM of this example

    EjenID ProductID Amount Month
    1 41 2 9
    2 40 2 9
    1 40 3 9
    2 41 2 9
    1 42 2 10

    how can I get the result of this: to view the EjenID total Amount of
    purchase in Month=9

    look like this

    EjenID Amount Month
    1 5 9
    2 4 9

    thanx

    Sponsored Links
    muadzir@yahoo.com Guest

  2. #2

    Default Re: To query SUM of multiple row of the same key id

    com wrote: 
    SELECT EjenID, SUM(Amount), Month FROM table_name WHERE Month = 9 GROUP
    BY EjenID, Month
    Jeff Guest

  3. #3

    Default Re: To query SUM of multiple row of the same key id

    Thanks Jeff it works...

    appreciate that

    adzir Guest

Similar Threads

  1. multiple lookups in one query
    By Wild Bill Hiccup in forum MySQL
    Replies: 7
    Last Post: March 9th, 03:37 PM
  2. multiple field query - plus
    By Durwood Edwards in forum Macromedia Dynamic HTML
    Replies: 0
    Last Post: July 7th, 06:19 PM
  3. Query using multiple databases?
    By Gary1 in forum Coldfusion - Advanced Techniques
    Replies: 4
    Last Post: July 4th, 11:44 AM
  4. CAML Query: Multiple Query Fields Issue
    By Jon F. in forum ASP.NET Web Services
    Replies: 0
    Last Post: May 12th, 08:19 PM
  5. multiple db query
    By Aris Santillan in forum PHP Development
    Replies: 2
    Last Post: September 2nd, 11:07 AM

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