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

How do I restart sql?

0 Answers  

---

Is nosql relational?

0 Answers  

---

type type_name is table of varchar2(30) index by binary_integer for the above type you have to create a identifier... like identifier_name type_name; for the above type you can use the below methods..like first , last , prior, next , delege..etc...like this.. if you create a cursor...like cursor cursor_name is select * from scott.emp; is there any methods like above to use prior, fist , last , next , trim ,etc...

1 Answers   Satyam,

---

what is the difference between sql and t-sql? : Transact sql

0 Answers  

---

Which is faster union or join?

0 Answers  

---

Is nosql faster than sql?

0 Answers  

---

What is time based sql injection?

0 Answers  

---

What is crud sql?

0 Answers  

---

I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

7 Answers   MTS,

---

Can a foreign key be a duplicate?

0 Answers  

---

Can I call a procedure inside a function?

0 Answers  

---

wa procedure to return the month and the no'f developers joined in each month.

4 Answers   Fidelity,

---