Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used
- 11 Answers
- 18775 Views
- UST, I also Faced
- E-Mail Answers
Answer Posted / lakshya
SELECT * FROM table_name
WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM table_name GROUP
BY table_columns);
| Is This Answer Correct ? | 9 Yes | 8 No |
Post New Answer View All Answers
difference between anonymous blocks and sub-programs.
What are the types of join and explain each?
Is pl sql better than 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
what are different types of collation sensitivity? : Sql dba
what does the t-sql command ident_current does? : Transact sql
Is it possible to link two groups inside a cross products after the cross products group has been created?
Which one is better sql or oracle?
What are the advantages of indexing?
What is difference between hql and native sql?
What is dcl in sql?
What are the packages in pl sql?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
What is mdb stand for?
Why do we use procedures in sql?
