How do I output the "most" in MySql?
update employee as a 
      set a.suprole=(
                    select b.jobroll from employee as b 
                           where b.supervisorid=a.employeeid 
                           group by b.jobroll 
                           order by count(b.jobroll) desc 
                           limit 1
                     ) 
       where a.jobroll='generic manager';