prova
select userid,id from tabella where flagtop=1 group by userid;


oppure

select userid,id from tabella where flagtop=1 group by userid,id;

semmai se va fammi saper