select * from <table_name> where <column

How to retrieve Duplicate Rows only in a Table?
Suppose if a Table Name is "Education". It consists of
multiple columns. Then if we insert rows into this table
with duplicate records then how can we retrieve only
duplicate records from that table?

Question Posted / cesar di sanctis

29 Answers
50685 Views
Alps, Aricent, Bank Of America, Wipro, I also Faced
E-Mail Answers

Answer Posted / cesar di sanctis

select * from <table_name>
where <column_name> in
(select <column_name>
from <table_name>
group by <column_name>
having count(*) > 1)

Is This Answer Correct ?

6 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is difference sql and mysql?

939

What is a unique key and primary key and foreign key?

918

What are the two types of periodical indexes?

886

Why is pl sql needed?

874

Is primary key clustered or nonclustered?

951

How do sql databases work?

943

What are the basic techniques of indexing?

1012

what are the different type of normalization? : Sql dba

969

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1092

how would you enter characters as hex numbers? : Sql dba

935

what is sql in mysql? : Sql dba

1120

What is the difference between left join and right join?

887

Can unique keys be null?

850

what is a tablespace? : Sql dba

1004

Do foreign keys improve performance?

965