Retrieve the top contacts associated with the account

[yash71029733]

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.

[Jonathon_wodnicki · Accepted solution]

Hi,

Sounds like an analyst interview question .

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

Thanks,

-Jon