loop help

Results 1 to 2 of 2

Thread: loop help

  1. #1
    Join Date
    Dec 1969

    Default loop help

    I need help with a loop that sums totals per an account number. When it gets to the next account number exit when it reaches a new account number, exits the loop and starts getting the totals for that account number. This loop should go on until the end of the table

  2. #2
    Join Date
    Dec 1969

    Default r and D GROUP BY .

    &nbsp;<BR>SQL:<BR><BR>select max(accountcode),count(accountcode) <BR><BR>from mytable<BR><BR>group by accountcode<BR>

Posting Permissions

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