Different ways of retrieving a tag cloud

-- http://poeticcode.wordpress.com/2007/01/27/tag-cloud-algorithmlogicformula/

select entity,metric from fact order by metric desc;
select entity,metric from fact ordre by metric desc limit 0,<n>;
select * from (select entity,metric from fact order by metric desc limit 0,<n>) order by entity;