Select distinct che non funge..

[piero.mac]

prova con group by

select CAP from  TB_CAP 
goup by CAP
order by CAP