select id,count(id) from Education group by id having count(id)>1

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 / sirisha

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

Answer Posted / sirisha

select id,count(id) from Education group by id having count(id)>1

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain locks? : Transact sql

1010

Can we rollback after truncate?

1034

How can the performance of a trigger be improved?

1047

Is nosql relational?

947

Can you join a table to itself?

1133

How much does sqlite cost?

1045

Why do we go for stored procedures?

1062

Explain what is rdbms?

1042

What is database migration?

973

Is sql sequential or random?

1039

How do I run a sql query?

1026

Which nosql database is best?

982

How global cursor can be declare with dynamic trigger ?

2211

What is rownum?

986

what is 'mysqladmin' in mysql? : Sql dba

1026