Which join is like inner join?

0 Answers  

---

Is it possible to use LONG columns in WHERE clause or ORDER BY?

3 Answers  

---

what is the difference between delete and truncate statement in sql? : Sql dba

0 Answers  

---

Explain the difference between 'between' & 'and' operators in sql

0 Answers  

---

What is field delimiter?

0 Answers  

---

---

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 Answers   IAS,

---

What is difference between inner join and cross join?

0 Answers  

---

How to install oracle sql developer?

0 Answers  

---

Which one is better subquery or joins?

0 Answers  

---

What is localdb mssqllocaldb?

0 Answers  

---

how can we write a column values horizontal by using sql stmt; ex: select name from table_name;(actual output) a b c d require output is a b c d

5 Answers   Honeywell, Interact,

---

What is TABLE SPACE?

4 Answers   ABB, TCS,

---