SELECT RNO,NAME,COUNT(*) REP_COL FROM Education GROUP BY RNO,NAME having

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

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

Answer Posted / seshu

SELECT RNO,NAME,COUNT(*) REP_COL FROM Education GROUP BY
RNO,NAME having Count(*)>1;

Is This Answer Correct ?

7 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Do ddl statements need commit?

931

What is primary key secondary key alternate key candidate key?

990

how can you see all indexes defined for a table? : Sql dba

947

Define SQL and state the differences between SQL and other conventional programming Languages?

1158

Do prepared statements prevent sql injection?

904

what is sp_pkeys? : Transact sql

1116

how to rename an existing table in mysql? : Sql dba

1013

What is the plv (pl/vision) package offers?

988

How do you delete a table?

1010

Can you rollback after commit?

941

Why are aggregate functions called so?

906

How bulk collect improves performance?

958

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1029

How does a self join work?

1006

What are aggregate and scalar functions?

982