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
- 51091 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 language is oracle sql developer?
What is a recursive join sql?
What is difference between stored procedure and trigger?
What are different types of triggers?
How do I add a database to sql?
What is foreign key sql?
Can we use commit inside a trigger?
What are the different operators available in sql?
what is log shipping? : Sql dba
how many ways to get the current time? : Sql dba
Is t sql a programming language?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
Does a user_objects view have an entry for a trigger?
What is interval partition?
what is an extent ? : Sql dba
