Hi,
I'm having a little problem i can't seem to solve. Here goes:
I want to select the top 10 or top 15 from a table that has account
a with multiply dollar values. For example
a1..30
a1..20
a1..100
a1..5
a1..99
b1..11
b2..1000
b3..3

and so on but each account can have like 30-40.
So i want to just select the top 10 for each acount and display it. And/Or put it into another
table.
I have tried selects and using a cursor but i just cant seem to get the logic worked out. I
keep getting the top 10 but not for each account.
So is anybody out there that can show me the way or if at all possible a solution.
Thanks in advance.

Your Confused Developer,
LcO