select count (column_name),column_name from table_name group by column

how to retrieve only duplicate values in a table

Question Posted / vijay_1994

Answer Posted / vijay_1994

select count (column_name),column_name from table_name group by column_name having count(column_name)>1;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are tables and fields in the database?

787

Can a view be mutating? If yes, then how?

784

What is pl/sql table? Why is it used?

780

How does pl sql work?

723

How do you optimize a stored procedure in sql?

709

What is error ora-12154: tns:could not resolve the connect identifier specified?

854

what is a materialized view? : Sql dba

782

Why do we need cursor in pl sql?

856

Is a foreign key always unique?

702

Which one is better sql or oracle?

725

Is pl sql a programming language?

743

Does a primary key have to be a number?

716

Why do we use function in pl sql?

803

How to combine two stored procedures in sql?

835

What does inner join mean?

788