SELECT COUNT(*), <COLUMN_NAME> FROM EDUCATION GROUP BY <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 / lavanya

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

Answer Posted / lavanya

SELECT COUNT(*), <COLUMN_NAME> FROM EDUCATION GROUP BY
<COLUMN_NAME>

Is This Answer Correct ?

10 Yes

14 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1119

What is bitemporal narrowing?

1298

What is varchar used for?

1074

Where is pl sql used?

948

What is write ahead logging in sql server?

1042

How can a function retun more than one value in oracle with proper example?

1071

What is rownum and rowid?

1027

What is the purpose of cursors in pl/sql?

1134

Explain mutating table error.

1194

what is csv? : Sql dba

993

What are the different types of joins in sql?

1771

What is primary key and unique key?

1112

How do I find sql profiler?

933

What are sql triggers used for?

988

How do rank () and dense_rank () differ?

1042