Cita:
Iniciado por Linterns prueba con lo siguiente
Código:
(select country, count(provider_id) as total
from provider group by country order by total DESC Limit 5)
UNION
(Select 'otros' as country, count(provider_id) as total
from provider
where not EXISTS (select country
from provider group by country order by count(provider_id) DESC Limit 5))
Gracias pero no funciona:
Código PHP:
Executing Query. Wait ...
MySQL ERROR:
Invalido uso de función en grupo