Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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