Answer / sangeetha meda

1. Self Join
Self join is a query in which a table is Joined to itself.

Self joins are used to compare the values in a column to
the other values in the same column in the same table.

2.Equi Join or Inner join
Equi join is a join in which the rows are retrieved the
equality of the relation ship between columns in the tables.

Select only those rows that have values in common in the
columns specified in the ON clause.

3.Non Equi Join or Outer Join

Left Outer Join:

Retrieves the matching records in both the table and non
matching records in the first or left table.

Right Outer Join

retrieves the matching records in both the table and non
matching records in the second or the right table.

Full Outer Join

Retrieves all the records (means matching and non matching
records in both the tables).

Answer / deeksha

4 types
1.equijoin
2.non-equijoin
3.self join
4.outer join

Answer / mohana sundaram

self joins,natural joins,cross joins,inner joins,outer
joins,equi and nonequi joins.

Answer / roopesh kumar

(1) Inner or Equei join
(2) Outer or no - equei join
(a) left outer
(b) right outer
(c) full outer
(3) Cartision or cross join
(4) Self join
(5) Natural join

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

0 Answers  

---

What is normalization and types of normalization?

22 Answers   Etisbew, F-TEC, Microsoft, TechProcess,

---

Can a table contain multiple foreign key’s?

0 Answers  

---

Is json a nosql?

0 Answers  

---

What version is sql?

0 Answers  

---

What is before trigger?

0 Answers  

---

diff b/w sub query and co-relater query?

3 Answers   iFlex,

---

What do you mean by stored procedures? How do we use it?

0 Answers  

---

What is cursor status?

0 Answers  

---

What is the difference between partitioning and sharding?

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,

---

What is scalar function in sql?

0 Answers  

---