Answer Posted / guru

select max(salary) from Employee where salary not in(select
top (n-1) salary from Employee order by salary desc)

What is primary key index?

982

---

What type of locking occurs during the snapshot generation? : sql server replication

1333

---

Explain what stored procedure sp_replcounters is used for? : sql server replication

1523

---

What are cursors and when they are useful?

1090

---

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

986

---

What do you understand by intent locks?

1014

---

What is a dataset and what are the different types of datasets?

136

---

How do you handle datasets larger than 50 gb?

162

---

Define tempdb database?

1004

---

Explain full-text query in sql server?

1011

---

How to manipulate data from one table to another table ?

969

---

What’s the use of custom fields in report?

944

---

What is the xml datatype?

1083

---

What are the different types of sql server replication? : sql server replication

1277

---

How to recreate an existing index in ms sql server?

1060

---