Duplicate SuperUser accounts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Super User

Q&A for computer enthusiasts and power users

select u.id as [User Link], u.accountid, * 
from users u
inner join (
select accountid
from users
where accountid is not null
group by accountid
having count(*)> 1) da on da.accountid = u.accountid
order by u.accountid

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results