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 cursor in pl sql?

561

what are the disadvantages of mysql? : Sql dba

557

What is sqlcommand?

542

What are all the different normalization?

547

Which data dictionary views have the information on the triggers that are available in the database?

739

What are the properties of a transaction?

545

How to run pl sql program in mysql?

502

What is the use of triggers?

530

Are pl sql variables case sensitive?

586

What plvcmt and plvrb does in pl/sql?

862

What are inner outer left and right joins in sql?

499

What does count (*) do in sql?

514

What is a loop in sql?

556

What do you think about pl/sql?

521

Is pl sql a programming language?

533