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 the difference between truncate and drop statements? : Sql dba

1106

Sql technical questions

1263

What is plpgsql language?

1052

What is the difference between inner join and natural join?

997

Which are the different character-manipulation functions in sql?

1053

Can triggers stop a dml statement from executing on a table?

1077

How many functions are there in sql?

1002

what are all different types of collation sensitivity? : Sql dba

976

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1138

What is the difference between a database and a relational database?

1094

how to use 'mysql' to run sql statements? : Sql dba

1040

What is the purpose of normalization?

1037

What is record data type?

906

Why is pl sql used?

974

what is meant by urlencode and urldocode? : Sql dba

1166