What is right join in sql?

0 Answers  

---

Is mariadb a nosql database?

0 Answers  

---

What are the qualities of 2nf?

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,

---

Does sql*plus have a pl/sql engine?

0 Answers  

---

How many primary keys can a table have?

0 Answers  

---

2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B

2 Answers   Fintellix,

---

How show all rows in sql?

0 Answers  

---

Explain some predefined exceptions.

0 Answers  

---

Explain architecture of sql server notification services?

0 Answers  

---

How do I view stored procedures?

0 Answers  

---

what is Complex index. how to create it?

2 Answers  

---