Select complesso

[nicola75ss]

Se puoi utilizzare le subquery prova così:

SELECT * FROM
(select * from animali order BY campo_quantita desc limit 3) as tabDerivata order by animali;