Answer / kilari hemadri

Joins is used to relate two tables and display the result..
types of joins are

inner join
left join
right join
full join
cross join

inner join : It is used to display the common values in
both the tables based on the condition given.

left join : Left join displays all the contents of left
table and dislays the right table contents that are present
in left table.

right join : it is contraversy to left join

full join : it is combination of both left and right joins.

cross join: it takes one row of left table and matches with
all the rows in the right table.

Answer / jiya jain

The nature of relational database design shows that we will
have related data that is stored in different tables. To
retrieve data from two or more tables we use JOINS.

The JOIN clause tells the database how the data in the two
tables is related so that it can return a correct
representation of the related data.

There are different types of join.

Types of Join are :
1.Self Join
2.Inner Join
3.Outer Join
3.1. Right Outer Join
3.2. Left Outer Join
3.3 Full Outer Join
4.Cross join College Table

For more info go through

http://www.totaldotnet.com/Article/ShowArticle61_SqlServerJo
ins.aspx

Answer / mahesh

joins are used to relate two tables and display the result..

Types of join

1.inner join
2.outer join
2.1 left outer join
2.2 right outer join
2.3 full outre join
3.cross join

Answer / udaykumar

Join - joining of two tables to itself.
types of joins.....
simple/equi/inner
self
outer
cartesian.

Answer / dinesh kumar

Joins -- Getting related data from more than one table.

Type:
Inner JOin --Equi Join -- Non Equi join
Outer JOin --LEft Join -- Right Join -- Full Outer JOin
CRoss Join

What is a schema in sql?

1 Answers  

How to fetch alternate records from a table?

0 Answers  

What is bitemporal narrowing?

0 Answers  

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

0 Answers  

What is a file delimiter?

0 Answers  

What is the advantage of index in sql?

0 Answers  

What is the basic structure of PL/SQL ?

6 Answers  

How to call shell script from pl sql procedure?

0 Answers  

i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?

4 Answers   Tech Mahindra,

What is trigger in pl sql with examples?

0 Answers  

declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....

3 Answers   Satyam,

What are the most important ddl statements in sql?

0 Answers