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
- 50641 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / seshu
SELECT RNO,NAME,COUNT(*) REP_COL FROM Education GROUP BY
RNO,NAME having Count(*)>1;
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
What is the use of sqlerrd 3?
how to fetch alternate records from a table? : Sql dba
Are null values same as that of zero or a blank space?
what is the difference between a web-garden and a web-farm? : Sql dba
Why truncate is faster than delete?
How many types of triggers are there in pl sql?
What is mutating sql table?
Write the alter statement to enable all the triggers on the t.students table.
What are the different types of constraints?
Explain cursor types?
what are the different type of sql's statements ? : Sql dba
What is offset in sql query?
What is the most important ddl statements in sql are?
What is the difference among union, minus and intersect?
Why do we need cursor in pl sql?
