quick query question

Results 1 to 2 of 2

Thread: quick query question

  1. #1
    Join Date
    Dec 1969

    Default quick query question

    here is my sample table<BR><BR>name points<BR><BR>jim 10<BR>bob 11<BR>kate 9<BR>jim 11<BR>bob 9<BR>kate 9<BR>sally 12<BR><BR>i need a query that will return the total points for each name.<BR><BR>please help. thanks in advance.

  2. #2
    Join Date
    Dec 1969

    Default RE: quick query question

    select [name], sum(points) from &#060;table&#062; Group BY [name]

Posting Permissions

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