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 types of index in sql?

778

What is data type in sql?

729

What is the difference between mdf and ndf files?

783

What is substitution variable in pl sql?

695

How do I view stored procedures?

739

Why is there a need for sqlcode and sqlerrm variables?

760

What is varchar used for?

753

Is merge a dml statement?

731

What are the two types of exceptions.

826

What is nested table in pl sql?

748

How to move files from one directory to another in pl sql?

858

What is data control language?

736

how to start mysql server? : Sql dba

866

explain advantages of myisam over innodb? : Sql dba

804

What is data definition language?

803