Finding the highest COUNT in a GROUP BY query

(Rudy Limeback) I retrieve two columns named SuperVisor and totalcontracts using this query: select SuperVisor, count(ContractNo) as totalcontracts from Contract group by SuperVisor Now I want to get the maximum of totalcontracts from the retrieved data using a select statement. (R)

Read More - Register for Free Membership