2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

What is update locks?

0 Answers  

---

What is difference between inner join and full join?

0 Answers  

---

What is master database? : SQL Server Architecture

0 Answers  

---

What is an extended Stored Procedure?

1 Answers  

---

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

0 Answers  

---

How do I create a trace in sql server?

0 Answers  

---

How to Generate a Series of Random Integers With T-SQL?

1 Answers  

---

Difference between Inner vs outer joins?

0 Answers  

---

event classes in sql server

2 Answers   Accenture, AFE,

---

Tell me about normalization in DBMS.

0 Answers   Honeywell, Zomato,

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

0 Answers  

---