select user_code, b.user_fullname
from d_user a,
(select user_fullname, count(user_fullname) cfname
From d_user
where b_enabled = 1
and user_Type like '%S%'
Group By user_fullname
Having Count(1) > 1) b
where a.user_fullname = b.user_fullname
from d_user a,
(select user_fullname, count(user_fullname) cfname
From d_user
where b_enabled = 1
and user_Type like '%S%'
Group By user_fullname
Having Count(1) > 1) b
where a.user_fullname = b.user_fullname