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 the built in functions of sql?

995

Why is sql important?

1036

What is snowflake sql?

1021

What is sql and also describe types of sql statements?

1014

What are character functions?

1049

What is trigger types in sql?

957

How does postgresql compare to oracle/db2/ms sql server/informix?

991

What is the difference between cross join and natural join?

973

What is oracle sql developer?

1004

How do I count duplicates in sql?

1048

How to run sql*plus commands in sql developer?

1098

how to use in conditions? : Sql dba

973

what are date and time intervals? : Sql dba

1010

Which operator is used in query for pattern matching?

1046

What is the difference between function, procedure and package in pl/sql?

1164