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
- 51806 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / bhuvi
use self join and find the intersection
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is 'mysqlshow'? : Sql dba
Differentiate between % rowtype and type record.
What are pl sql procedures?
How do you remove duplicates without using distinct in sql?
Can we use ddl statements in stored procedure?
How to create a menu in sqlplus or pl/sql?
What is the use of sqldataadapter?
What is the difference between database trigger and stored procedure?
Why do we need pl sql?
What are synonyms in sql?
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
Explain what is a subquery ?
Which sql statement is used to delete data from a database?
Is it possible to link two groups inside a cross products after the cross products group has been created?
Is there a way to automate sql execution from the command-line, batch job or shell script?
