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.

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

---

Define master database?

0 Answers  

---

What is best institute to Learn DotNET And SQL in chennai?

0 Answers  

---

How to verify a login name with sqlcmd tool?

0 Answers  

---

Explain temporary table vs table variable by using cursor alternative?

0 Answers  

---

What are the disadvantages of indexes?

0 Answers  

---

What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)

1 Answers  

---

What are the advantages of using third-party tools?

0 Answers  

---

Explain different isolation levels?

4 Answers  

---

what is performance tunning in sql server ? explain.

1 Answers   Thomson Reuters,

---

What happens if you are trying to access a schema not owned by you?

0 Answers  

---

What is the contrast between sql and mysql?

0 Answers  

---