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
51881 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 are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

958

What are properties of the transaction?

998

What is sql and also describe types of sql statements?

1066

What is cold data?

966

How do I trace sql profiler?

986

Explain the working of primary key?

1099

What is rownum?

985

How to avoid duplicate records in a query?

1009

What is implicit cursor in pl sql?

1097

Why cross join is used?

1083

What is the use of count (*) in sql?

1057

What are different types of sql commands?

1118

What is sql in oracle?

1065

What is triggering circuit?

1071

Is it possible to sort a column using a column alias?

1052