from the table display the 2nd highest salary? and also the least 2nd salay?

8 Answers  

---

What is the Control Flow in SSIS

0 Answers   HCL,

---

explain different types of jions with examples briefly?

1 Answers   Zensar,

---

what is nonclustered index

0 Answers  

---

What is user-defined functions? What are the types of user-defined functions that can be created?

0 Answers  

---

---

How can you set the threshold at which sql server will generate keysets asynchronously?

0 Answers  

---

Explain different forms of normalization?

0 Answers  

---

How to create a large table with random data for index testing in ms sql server?

0 Answers  

---

can an order by clause be used in a creation of a view?

0 Answers  

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers  

---

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

0 Answers  

---

What are the advantages of using cte?

0 Answers  

---