SELECT * FROM EDUCATION E1 WHERE ROWID>(SELECT MIN(ROWID) FROM EDUCATI

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

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

Answer Posted / satheesh

SELECT * FROM EDUCATION E1 WHERE ROWID>(SELECT MIN(ROWID)
FROM EDUCATION E2 WHERE E1.EMPID=E2.EMPID)

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 the unique index?

1109

What is server name sql?

1204

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

4060

What is difference between joins and union?

1195

what is the functionality of the function htmlentities? : Sql dba

1006

What are the different types of sql commands?

1177

Is sql sequential or random?

1086

what is the difference between cluster and non cluster index? : Sql dba

1077

What is the least restrictive isolation level? : Transact sql

1106

What is lexical units in pl sql?

1207

What is the usage of nvl function?

1102

What is pl sql in dbms?

992

What does the base_object_type column shows in the user.triggers data dictionary view?

1097

Is left join inner or outer?

1057

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

1019