I have a structure where I've got 1 table of employee ID and branch ID and 1 table of customer ID and asset amount.
I would like to find out a list of 5 customer IDs with greatest assets for each of the employee ID. How do I go about doing this? I've run out of ideas with what little I know of SQL.
Question
Arpit
A newbie here with SQL and thanks in advance.
I have a structure where I've got 1 table of employee ID and branch ID and 1 table of customer ID and asset amount.
I would like to find out a list of 5 customer IDs with greatest assets for each of the employee ID. How do I go about doing this? I've run out of ideas with what little I know of SQL.
Link to comment
Share on other sites
17 answers to this question
Recommended Posts