Consulta ordenar mayor cantidad de votos.

[huesos52]

Código MySQL:

mysql> select *from votos;
+------------+--------+-------+
| dia        | idcont | votos |
+------------+--------+-------+
| 2010-01-12 |     24 |    56 |
| 2010-01-12 |     23 |    43 |
| 2010-01-12 |     23 |    34 |
| 2010-01-12 |     24 |     2 |
+------------+--------+-------+
4 rows in set (0.00 sec)
 
mysql> select sum(votos) total_votos, idcont from votos group by idcont order by total_votos desc;
+-------------+--------+
| total_votos | idcont |
+-------------+--------+
|          77 |     23 |
|          58 |     24 |
+-------------+--------+
2 rows in set (0.00 sec)
 
 
mysql>
 

saludos