Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 29 Answers
- 52602 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / dev
SELECT * FROM TAB1 A WHERE A.ROWID > ANY
(SELECT B.ROWID FROM TAB2 WHERE A.COL1=B.COL1)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the usage of the distinct keyword?
What is sql dialect?
Write a sql query to get the third highest salary of an employee from employee_table?
What is the difference between having clause and where clause?
What does stand for in sql?
What is trigger in sql and its types?
Why do we use %rowtype & %type in plsql?
How to handle bulk data?
How do you delete duplicates in sql query using rowid?
What is trigger in sql?
What are the two different parts of the pl/sql packages?
How many joins in sql?
How do you determine the current isolation level? : Transact sql
Are stored procedures faster than queries?
Explain the select statement in sql?
