select Student_Name,Dgree from Education group by (Student

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

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

Answer Posted / keerthana

select Student_Name,Dgree from Education
group by (Student_Name,Dgree) having count(*) > 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 is dialect in sql?

987

Explain the uses of database trigger.

1175

describe transaction-safe table types in mysql : sql dba

1059

Can we use pl sql in sql server?

1136

Is sql sequential or random?

1086

Explain the difference between rename and alias?

1068

What is scalar data type in pl sql?

1119

what is offset-fetch filter in tsql? : Transact sql

998

What are procedures used for?

1036

What is varray in pl sql?

1121

How do you sort in sql?

1071

what is the difference between join and union? : Sql dba

1202

What is update query?

1033

what is the difference between a having clause and a where clause? : Sql dba

1158

How do I install sql?

1045