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 is sql dialect?

1035

How insert into statements in sql?

1007

can a stored procedure call itself or recursive stored procedure? : Sql dba

955

Which sql most popular?

934

What are the operators used in select statements?

999

Can primary key be changed?

862

Why stored procedure is faster than query?

947

What is the process of copying data from table a to table b?

1033

explain the difference between delete , truncate and drop commands? : Sql dba

1013

What is a sql instance vs database?

1035

Can we edit a view in sql?

924

What is cursor and its types?

991

what are the advantages a stored procedure? : Sql dba

923

What is sql trigger example?

997

What is the current version of postgresql?

1004