select count(*),ss from dd group by ss having count(*)>1

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 / "d"

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

Answer Posted / "d"

select count(*),ss from dd group by
ss 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 pl sql quora?

1231

What are the different sql commands?

1127

what is query cache in mysql? : Sql dba

1081

What are the two types of cursors in pl sql?

1123

What is ttitle and btitle?

1113

Why do we need databases?

1089

How can we link a sql database to an existing android app?

1080

What are the advantages of stored procedure?

1040

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1172

what is union? : Sql dba

1082

How do you copy a table in sql?

1109

Why function is used in sql?

992

What is sqlservr exe?

1028

Can you have more than one key in a database?

993

How to sort the rows in sql.

1122