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
51632 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 happens when a trigger is associated to a view?

904

What jobs use sql?

975

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1112

Define tables and fields in a database

1119

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1086

What is the most restrictive isolation level? : Transact sql

1074

What is a schema sql?

1141

How to avoid using cursors?

1105

What is error ora-01000: maximum open cursors exceeded

1132

How many types of tables are there?

945

What is multiple columns?

1055

How do I run a sql script?

1130

Can I learn sql in a week?

1055

Are sql database names case sensitive?

993

Write a unique difference between a function and a stored procedure.

986