Retrieve the top contacts associated with the account

Avatar

Avatar

yash71029733

Avatar

yash71029733

yash71029733

14-08-2019

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.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

wodnicki

MVP

Avatar

wodnicki

MVP

wodnicki
MVP

14-08-2019

Hi,

Sounds like an analyst interview question .

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

Thanks,

-Jon

Answers (0)