How to find the second highest salary of an employee?

0 Answers  

---

Please explain what is “asynchronous” communication in sql server service broker?

0 Answers  

---

find the 3rd max salary

10 Answers  

---

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 transaction ? Give me one example.

11 Answers   Melstar, Wipro,

---

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  

---

What is an indexed view?

0 Answers  

---

What is onf in normalization form?

0 Answers  

---

in how many ways we can use count()

2 Answers  

---

What is user-defined scalar function?

0 Answers  

---

What does select 1 mean?

0 Answers  

---

What about UPDATESTATISTICS ?

2 Answers   HCL, Intelligroup,

---