Answer / g.ramesh

Inner Join is default type of join.
It produce result set, which contain's only matched rows.

Answer / prasanna

Inner joins use a comparison operator(like = or <>)to match
rows from two tables based on the values in common columns
from each table.It is a default type of join.
These includes Equi Joins and Natural Joins.

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

---

How do you read transaction logs

1 Answers  

---

How to find the last update record in SQL Server?

4 Answers  

---

Explain the xml support sql server extends?

0 Answers  

---

What is the difference between join and inner join?

0 Answers  

---

What are alternate keys?

0 Answers  

---

How column data types are determined in a view?

0 Answers  

---

Explain datetime2 data type in sal server 2008?

0 Answers  

---

Explain what is public role in sql server?

0 Answers  

---

Explain the new features of SQL server 2000?

1 Answers  

---

What is constraints and its types?

0 Answers  

---

What is read committed?

0 Answers  

---