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

What is rollback?

1115

Are null values same as that of zero or a blank space?

1028

What are the advantages of stored procedure?

1005

Do stored procedures prevent sql injection?

968

What is query execution plan in sql?

1189

What is full join?

954

what is index? : Sql dba

1006

what is a cursor? : Sql dba

1024

What is the difference between the implicit and explicit cursors?

1052

what is the difference between truncate and delete statement? : Transact sql

1064

What is the difference between in and between in sql?

1061

Why truncate is faster than delete?

1114

What is the difference between stored procedure and view?

1020

Does oracle use sql?

931

Explain the purpose of %type and %rowtype data types?

928