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,

---

Equi join and non equi join is possible with sql server?

0 Answers  

---

What is the purpose of the tempdb database?

0 Answers  

---

Creating Tables Using SELECT

1 Answers  

---

Write a program to fetch first 10 records from a file?

0 Answers   Amdocs,

---

How to find the date and time of last updated table?

6 Answers   Teledata,

---

What is entity data services?

0 Answers  

---

In which tcp/ip port does sql server run? Can it be changed?

0 Answers  

---

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

0 Answers   IGT,

---

Do you know concepts and capabilities of sql server?

0 Answers  

---

What is checkpoint in sql server?

0 Answers  

---

Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

7 Answers   TCS,

---