Results 1 to 2 of 2

Thread: SQL help- max value

  1. 09-19-2015, 10:34 PM #1
    rkirsch
    rkirsch is offline Registered User
    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.
    Reply With Quote Reply With Quote
  2. 09-22-2015, 10:54 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Use group by sales person and max(netsales)
    http://databaseandstorage.blogspot.com
    http://gotodba.weebly.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules