Is it possible to only display the largest calculated table column? Below is a code to sum all rows in each column where the value of each column c(x) equals 1. It gives me six columns containing each calculated sum. Is it possible to only display the largest calculated column (c4 as given by the image below) in a neat way?

SELECT DISTINCT 
       (SELECT SUM(`vote_candidate_1`) 
          FROM `votes` 
         WHERE `vote_candidate_1` = 1) c1
     , (SELECT SUM(`vote_candidate_2`) 
          FROM `votes` 
         WHERE `vote_candidate_2` = 1) c2
     , (SELECT SUM(`vote_candidate_3`) 
          FROM `votes` 
         WHERE `vote_candidate_3` = 1) c3
     , (SELECT SUM(`vote_candidate_4`) 
          FROM `votes` 
         WHERE `vote_candidate_4` = 1) c4
     , (SELECT SUM(`vote_candidate_5`) 
          FROM `votes` 
         WHERE `vote_candidate_5` = 1) c5
     , (SELECT SUM(`vote_candidate_6`) 
          FROM `votes` 
         WHERE `vote_candidate_6` = 1) c6 
  FROM `votes`;
Atleast for 8.0 there's the GREATEST function. I would also suggest that you do one scan against the table instead of six:

SELECT GREATEST(SUM(CASE WHEN vote_candidate_1 = 1
                         THEN vote_candidate_1 END)
              , SUM(CASE WHEN vote_candidate_2 = 1 
                         THEN vote_candidate_2 END)
              , SUM(...)
               ) as ...
FROM votes;