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
1 3933Post New IAS SQL PLSQL Interview Questions
What are the different types of embedded data flow?
how to use the regular expression for the below code-- swf("application name").swftreeview ("Treename").select"Medication;Pharmacy:56" There is a tree view window of the folder's ie Medication- >Pharmacy(sub folder)with 56 as count of records...The records can be different or if no records present in the specific folder..then it show "Paharmacy:-no records".Whe i record at the first time .....and try to rerun the same script with different records count say "pharmacy:800"..qtp is not regnizing it...therefore i want to user regular expression..but donot now how to use it and where to use...i have tried.... swf("application name").swftreeview ("Treename").select"Medication;Pharmacy:\*"..but it s of no use..plz help..me
What is the difference between transaction and transaction instance in loadrunner ?
Explain about map and their types?
Can I use ReaderWriterLock instead of Monitor.Enter/Exit for Threading?
What do you mean by component in cakephp? List some commonly used components.
Define the types of bus used in the 8085?
Is the primary key an index?
What are scalar functions?
Name the four most important components of a Freon refrigeration system.
What Is A Conversion Constructor C++ ?
Will installing ubuntu erase windows?
What command is used to check the current users?
What are null cells?
What is the purpose of an interface?