Retrieve the top contacts associated with the account

Avatar

Avatar
Validate 1
Level 2
yash71029733
Level 2

Likes

17 likes

Total Posts

26 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
yash71029733
Level 2

Likes

17 likes

Total Posts

26 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
yash71029733
Level 2

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
Establish
MVP
wodnicki
MVP

Likes

986 likes

Total Posts

1,097 posts

Correct reply

518 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

986 likes

Total Posts

1,097 posts

Correct reply

518 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
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)