Professional Web Applications Themes

Calculate ulative - MySQL

Hi, I have a database where I have to find the summation of points for each person. The example below has the name repeating multiple times. I am new to mysql. Would you please let me know what query would be good for getting what I want? The sample is below. Thanks: Name | Points Jack 10 Mack 20 Jack 25 Jack 25 Mack 30 John 5 Jack 10 John 10 John 5 Jill 10 John 30 Jill 10...

  1. #1

    Default Calculate ulative

    Hi,
    I have a database where I have to find the summation of points for
    each person. The example below has the name repeating multiple times. I
    am new to mysql. Would you please let me know what query would be good
    for getting what I want? The sample is below.

    Thanks:

    Name | Points
    Jack 10
    Mack 20
    Jack 25
    Jack 25
    Mack 30
    John 5
    Jack 10
    John 10
    John 5
    Jill 10
    John 30
    Jill 10

    premgrps@gmail.com Guest

  2. #2

    Default Re: Calculate ulative

    [email]premgrps[/email] wrote:
    > Hi,
    > I have a database where I have to find the summation of points for
    > each person. The example below has the name repeating multiple times.
    > I am new to mysql. Would you please let me know what query would be
    > good for getting what I want? The sample is below.
    >
    > Thanks:
    >
    > Name | Points
    > Jack 10
    > Mack 20
    > Jack 25
    > Jack 25
    > Mack 30
    > John 5
    > Jack 10
    > John 10
    > John 5
    > Jill 10
    > John 30
    > Jill 10
    SELECT name, sum(points) from mytable group by name


    Paul Lautman Guest

Similar Threads

  1. Installing ulative Hot Fix 2
    By tsongas in forum Coldfusion Server Administration
    Replies: 3
    Last Post: August 14th, 04:28 PM
  2. Installing ulative Hot Fixes
    By Christopher Hayes in forum Coldfusion - Getting Started
    Replies: 1
    Last Post: July 14th, 08:30 PM
  3. CFMX7 ulative Hot Fix - where does it go?
    By DBinCO in forum Coldfusion Server Administration
    Replies: 1
    Last Post: June 1st, 08:48 PM
  4. June 2003, ulative Patch
    By Maurice in forum Windows Setup, Administration & Security
    Replies: 1
    Last Post: July 3rd, 07:36 AM
  5. July 2003, ulative Patch
    By Earl F. Parrish in forum Windows Setup, Administration & Security
    Replies: 1
    Last Post: July 2nd, 03:50 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