I am not familiar with top (does not seem to exist in oracle which I use), but you should be able to apply unique to a single column. I.e.

select unique(columnA), columnB from tableC where ...

since I don't seem to have a top function I have no idea if that helps though :-)

-Mike

_________________________
EmpMenuX - ext3 filesystem - Empeg iTunes integration