how to calculate the difference between two dates? : Sql dba

0 Answers  

---

What is sql rowcount?

0 Answers  

---

What are the three forms of normalization?

0 Answers  

---

Which one of the following join types will always create a Cartesian Product? 1. CROSS JOIN 2. LEFT OUTER JOIN 3. RIGHT OUTER JOIN 4. FULL OUTER JOIN 5. INNER JOIN

2 Answers  

---

When do we use triggers?

0 Answers  

---

---

How do you truncate?

0 Answers  

---

how to dump a table to a file with 'mysqldump'? : Sql dba

0 Answers  

---

Does pl sql work in mysql?

0 Answers  

---

What is transaction control language (tcl)?

0 Answers  

---

What is union?

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,

---

I want to know the difference between A Record Type and a Table.

3 Answers   Thermotech,

---