you can try with group by clause as follows:
select <col_A> from <table_name> group by <col_A> having count(*) > 1;
this will give the duplicate values for column A. Hope this helps.
Register Hereor login if you are already a member
select column_name, count(column_name)
group by column_name
having count (column_name) > 1;