Results 1 to 2 of 2

Thread: SQL help- max value

  1. #1
    Join Date
    Sep 2015
    Posts
    1

    SQL help- max value

    I am trying to find the highest single store sales for each salesperson based on a table with the following columns: SalesPerson, NetSales, and StoreID. Everything I try to run returns multiple entries for each SalesPerson instead of just 1.

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Use group by sales person and max(netsales)

Posting Permissions

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