Retrieve the top contacts associated with the account | Community
Skip to main content
Y
YashP1
Level 2
August 14, 2019
Solved

Retrieve the top contacts associated with the account

  • August 14, 2019
  • 1 reply
  • 1169 views

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.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Jonathon_wodnicki

    Hi,

    Sounds like an analyst interview question .

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

    Thanks,

    -Jon

    1 reply

    Jonathon_wodnicki
    Community Advisor
    Jonathon_wodnickiCommunity AdvisorAccepted solution
    Community Advisor
    August 14, 2019

    Hi,

    Sounds like an analyst interview question .

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

    Thanks,

    -Jon

      Terms & ConditionsAccessibility statement

      Loading footer...