Answer Posted / dewashish kumar pal

Select max(salary) from tablename where salary not in (select max(salary) from tablename);

on line cluster can we make if yes tell me the procedure

2068

---

what are the different stages of Report Processing?

141

---

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

141

---

What is database replication?

1211

---

What is history table in sql server?

1037

---

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

1047

---

How to retrieve error messages using odbc_errormsg()?

1110

---

What is outer join in sql server joins?

1188

---

How will you go about resolving deadlocks?

1036

---

What do we need queues in sql service broker?

1124

---

What is parameterized reports in ssrs ?

163

---

Can you explain various data region available in ssrs with their use?

1024

---

what's new in sql server 2016?

1003

---

What are cursors and when they are useful?

1153

---

What happens if the update subquery returns multiple rows in ms sql server?

1171

---