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
50723 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

Does sql view stored data?

900

how to decrement dates by 1 in mysql? : Sql dba

970

Is sql difficult?

1107

Is mariadb nosql?

993

What is the use of sqldataadapter?

911

What are inner outer left and right joins in sql?

965

What is bulk collect in pl sql?

1021

What is the difference between distinct and unique in sql?

876

What are the most important characteristics of pl/sql?

1080

What are the topics in pl sql?

932

What is a recursive stored procedure?

1098

What is cursor status?

1135

What is sql integrity?

1064

What is the sql case statement?

954

What is rownum and rowid?

985