starbird2273
IS-IT--Management
OK, I am trying to get a query to run from one table. My results should be the top ten dollar balance amounts for EVERY Customer ID in a table.
Table Structure (Important Feilds, I can add supporting feilds later)
Customer ID
Open Balance Amount
I have tried the queries from the following links, as well as others, and only get the top ten dollars total (so ten records)
Also, not every customer may have ten records, so I would need to pull all the records (see customer 789 below)
Basically, what I want is the following for output.
CustomerID Open Balance Amount
123 $10000
123 $9000
123 $8000
123 $7000
123 $6000
123 $5000
123 $4000
123 $3000
123 $2000
123 $1000
456 $10000
456 $9750
456 $9500
456 $9250
456 $9000
456 $8750
456 $8500
456 $8250
456 $8000
456 $7750
789 $50
789 $30
789 $20
Table Structure (Important Feilds, I can add supporting feilds later)
Customer ID
Open Balance Amount
I have tried the queries from the following links, as well as others, and only get the top ten dollars total (so ten records)
Also, not every customer may have ten records, so I would need to pull all the records (see customer 789 below)
Basically, what I want is the following for output.
CustomerID Open Balance Amount
123 $10000
123 $9000
123 $8000
123 $7000
123 $6000
123 $5000
123 $4000
123 $3000
123 $2000
123 $1000
456 $10000
456 $9750
456 $9500
456 $9250
456 $9000
456 $8750
456 $8500
456 $8250
456 $8000
456 $7750
789 $50
789 $30
789 $20