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
- 50968 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / balaji
For Sample:
----------
select count(pmid) as Occurances,pmid from tablename group
by pmid having count(pmid)>1
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
what is a composite primary key ? : Sql dba
What are % type and % rowtype?
What is a database event trigger?
How do you update f as m and m as f from the below table testtable?
Can you selectively load only those records that you need? : aql loader
What is the most important ddl statements in sql are?
How do I write a cron which will run a sql query and mail the results to agroup?
Which operator is used in query for pattern matching?
What is union and union all keyword in sql?
What is a join?
Is inner join faster than left join?
Explain aggregate functions are available there in sql?
Is sql injection illegal?
What is pivot table in sql?
Does normalization improve performance?
