Hi nxciro,

try removing the distinct, you don't need it.

select xrnd, count(xrnd) from t1
group by xrnd
order by count(xrnd) desc

Regards
Ian Newby