Answer / dhivya

Joins are used to fetch the records from more than one
table ,there are 4 types of joins
1.Equi-Join
2.Non-Equi-join
3.outer-join
4.Self-join

Answer / kavita

Join are used to link then retrive data from same or
different database(both have atleast one common attribute).

Join are basically of two types:
1)Equi Join
2) Non equi join

Equi join are those in which we use "=" operator in
condition.They are further divided into
a)inner join:-In this only those rows are return which
satisfy the condition.

b)Outer join:In this all rows are return in which either one
table satisfy the condition
Outer Join are again classified into left join and right join.

2)Non Equi Join are those in which we use ">","<",">=","<="
operator for retriving tuples from two tables

What is a database development?

1 Answers  

---

Explain about the relational database?

1 Answers  

---

How long can an error message be in raiseerror function?

1 Answers  

---

Explain about xml databases?

1 Answers  

---

What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

1 Answers  

---

Where is dbms used?

1 Answers  

---

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

1 Answers  

---

Which four data types cannot be used as a return type from a user-defined function?

1 Answers  

---

Explain the general syntax for a SELECT statements covering all the options.

3 Answers  

---

hi in which phase of mload can i use .FILLER

1 Answers   IBM,

---

Explain the cube operator?

1 Answers  

---

I have a few records all are same structures data, I want to store data in multiple targets how

1 Answers   CTR, Infosys, Polaris,

---