Results 1 to 2 of 2

Thread: Ranking

  1. #1
    Join Date
    Dec 2012
    Posts
    15

    Unanswered: Ranking

    I have store location and customers.

    I want my query to only obtain the top 50 customers per location based on sales.

    my sql is so-so. any help here?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    So you want to use the SELECT TOP and a GROUP BY.....
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •