select *
from tbl_name
where col_name in
(select col_name
from tbl_name
group by col_name
having count(col_name) > 1)
from tbl_name
where col_name in
(select col_name
from tbl_name
group by col_name
having count(col_name) > 1)