Answer / prasanna

1.Inner Join
- Equi Join
- Natural Join
2.Outer Join
- Left Outer Join Or Left Join
- Right Outer Join Or Right Join
- Full Outer Join Or Full Join
3.Cross Join
4.Self Join

Answer / mpg

There are 5 types of join in sql server 2005

inner join
outer join
cross join
equi join
self join

Answer / rupinder kaur

there are five types:
inner join
outer join: left outer join,right outer join, full outer
join
equi join
cross join self join

Answer / kalyana chakravarthy maddipati

Apart all the joins above there is one more join it is

NO EQUI JOIN ie emp.deptno!= dept.deptno or one can use <> sign instead

Answer / vishal

1. Inner Join
2. Outer Join
- Left Outer Join
- Right Outer Join
- Full Outer Join
3. Cross Join

Answer / abi

Types of Joins
1.Inner Join
2.Outer Join
-- Left Outer Join
-- Right Outer Join
-- Full Outer Join
3.Self Join
4.Cross Join
5.Equi-Join
6.Cross Apply Join
7.Outer Apply Join

Answer / g.ramesh

Inner Join
Outer Join
Crros Join

Answer / kittu

inner join
outer join
cross join
equi join
self join

Answer / g.ramesh

Inner Join
Outer Join
Crros Join

if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?

2 Answers  

Detail about query optimizer?

0 Answers  

what is replication? where do u use Go Keyword?

1 Answers   Satyam,

WHAT OPERATOR PERFORMS PATTERN MATCHING?

2 Answers   CarrizalSoft Technologies, CTS,

how to get 25th row in any table in sqlserver can u tell me syntax

8 Answers  

Explain unique key in sql server?

0 Answers  

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

0 Answers  

How can we delete a table in sql server?

0 Answers  

What are the steps to process a single select statement?

0 Answers  

What is primary key index?

0 Answers  

Explain a differential backup?

0 Answers  

How is sql used in sql server?

0 Answers