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.
Printable View
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.
Use group by sales person and max(netsales)