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
52629 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 difference between join and union? : Sql dba

1202

How do I run a pl sql procedure in sql developer?

1022

Is ms sql traffic encrypted?

962

Does sql between include endpoints?

1060

What is sql injection vulnerability?

1005

what is table? : Sql dba

1109

how to install mysql? : Sql dba

1161

What are the operators in sql?

1070

How to select all records from the table?

1181

What is primary key and foreign key with example?

981

What is assignment operator in pl sql?

1087

What is the current version of sql?

1069

What does closing a cursor do?

1372

What is sql data?

1034

What is the difference between explicit and implicit cursors in oracle?

1115