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 is sql used in sql server?

0 Answers  

---

What is the security principal at the server level that represents your session?

0 Answers  

---

What does <> symbol mean?

0 Answers  

---

What is a rollup clause?

0 Answers  

---

What is data modification?

0 Answers  

---

---

What are partitioned views and distributed partitioned views?

0 Answers  

---

How cand Optimize SQL Server Stored Procedures

1 Answers  

---

What are user defined datatypes and when you should go for them?

1 Answers  

---

What is the difference between cube operator and rollup operator? : SQL Server Architecture

0 Answers  

---

What is de-normalization and when do you do it?

3 Answers  

---

What is referential integrity and how is it achieved?

1 Answers   Adea Solutions,

---

Explain what is cte (common table expression)?

0 Answers  

---