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
- 50717 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
Where is all the data on the internet stored?
What are the different dml commands in sql?
where are cookies actually stored on the hard disk? : Sql dba
Is sql better than access?
What is scalar and vector?
What is oracle sql developer?
What is an implicit commit?
How many types of relationship are there?
Does sql*plus also have a pl/sql engine?
Can we enter data in a table in design view?
What is difference between group by and partition by?
What is date functions?
Why are indexes and views important to an organization?
Why plvtab is considered as the easiest way to access the pl/sql table?
List and explain the different types of join clauses supported in ansi-standard sql?
