select duplicate record sql

select distinct userid from U_USER_GROUP
group by userid
having count(userid) > 1
order by userid

//// complex code to retrieve duplicate records ////
select userid, name
from U_USER_GROUP
where userid in
(select userid from U_USER_GROUP
group by userid
having count(userid)>1)
order by userid

////// delete duplicate records /////
delete FROM U_USER_GROUP e WHERE rowid>(SELECT MIN(ROWID) FROM U_USER_GROUP WHERE e.userid=userid)
go