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
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
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.