Answer / a.jyothsna

1)Self Join
2)Equi join (or)Inner Join
2.1)Non-equi Join
3)Outer Join
3.1) Left-Outer Join
3.2) Right-Outer Join
3.3) Full-Outer Join

Answer / desiraju venkata subramanya ka

types of joins
• outer join
• left join
• right join
• equi-join
• non-equi-join
• selfJoin

Answer / prakash

Proprietary Joins
----------------
EquiJoin
Non EquiJoin
Self Join
outer join

Compliant Joins
---------------
Cross Join
Natural Joins
Full or two sided outer joins
Arbitrary Joins

Answer / 123

cross join

explain the options of myisamchk to improve the performance of a table. : Sql dba

0 Answers  

---

How do I run sql?

0 Answers  

---

difference between SQL and C

1 Answers   Indus Software Technologies,

---

What is data control language (dcl)?

0 Answers  

---

What is the most restrictive isolation level? : Transact sql

0 Answers  

---

---

how many ways we can we find the current date using mysql? : Sql dba

0 Answers  

---

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

0 Answers   Satyam,

---

What is not null in sql?

0 Answers  

---

Can function return multiple values in sql?

0 Answers  

---

i need department wise top 2 employees salary.which logic i will use

17 Answers  

---

Is full outer join same as cross join?

0 Answers  

---

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

---