Answer / sravanthi

The Join keyword is used to query data from 2 or more
tables based on the relationship between the columns in the
table.

1. Join : Returns records when there is atleast one matched
record in both the tables.
2. Left Join : Returns all the records of the left table
irrespective match records in both the tables.
3. Right join : It is just reverse case of left join.
4. Full Join : Returns all the records from both the tables
irrespective matching.

how to get the salary in descending order with out using the keyword desc in sql

5 Answers   Ramco,

---

What are translations and its use? : sql server analysis services, ssas

0 Answers  

---

What is the difference between a local and a global temporary table?

0 Answers  

---

How to remove duplicate rows from table except one?

0 Answers  

---

What is the purpose of linked server configuration in sql server?

0 Answers  

---

---

How to Insert multiple rows with a single insert statement?

0 Answers  

---

Can you explain powershell included in sql server 2008?

0 Answers  

---

What is default port number for sql server 2000?

0 Answers  

---

When you use @@error and try-catch?

0 Answers  

---

How to remove duplicate rows from table?

0 Answers  

---

What happens if you delete a table that is used by a view?

0 Answers  

---

What is the meaning of resultset type_scroll_insensitive?

0 Answers  

---