Expand my Community achievements bar.

SOLVED

Retrieve the top contacts associated with the account

Avatar

Level 3

I have a list of accounts(company names) and associated to it is the list of contacts assigned some scores based on their interactions with us. I need to retrieve the top 5 contacts(based on scores assigned) associated with every account. Please advise on how to do this.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi,

Sounds like an analyst interview question .

Just add a split after your query and limit by sort.

Thanks,

-Jon

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hi,

Sounds like an analyst interview question .

Just add a split after your query and limit by sort.

Thanks,

-Jon