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,

---

How to generate create function script on an existing function?

0 Answers  

---

Is the log file is a part of file group?

0 Answers  

---

What is transaction server implicit?

0 Answers  

---

List out the differences between the clustered index and non-clustered index in sql server?

0 Answers  

---

---

What is the difference between a unique key and primary key?

0 Answers  

---

How global temporary tables are represented and its scope?

0 Answers  

---

can we give the identity for existing column of the table? (already table contains 10(1-10) unique randam records)

2 Answers  

---

How to create function without parameter in sql server?

0 Answers  

---

What the different topologies in which replication can be configured?

0 Answers  

---

What is the difference between distinct clause and group by clause?

2 Answers   HHH, Value Labs,

---

How do you optimize Sql queries ?

0 Answers   Cognizant,

---