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

What are three advantages to using sql?

977

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1045

Difference between table function and pipelined function?

984

Enlist the data types that can be used in pl/sql?

1030

What is sql partition?

1061

Which are the different case manipulation functions in sql?

975

define sql insert statement ? : Sql dba

989

What is pl sql and why it is used for?

1090

Which tcp/ip port does sql server run?

973

Is it possible to create startup or shutdown trigger for on-schema?

1002

Is primary key a clustered index?

948

What is sap sql?

947

What is gpt format?

912

What is sql and how does it work?

1121

What is a left inner join?

975