Answer Posted / saurabh

select max(salary) from Employee where salary not in (
select top 5 Salary from ( select distinct Salary from
Employee order by Salary desc))

How do I schedule a sql server profiler trace?

1026

---

what is blocking? : Sql server database administration

1085

---

What program is used to store the data source file?

1004

---

What is the order by used for?

1053

---

What is application role in sql server database security? : sql server security

1119

---

What is the difference between delete and truncate statements?

1127

---

How to use subqueries with the exists operators in ms sql server?

1175

---

User wants only to display only pdf as export option in report manager. How to achieve this?

269

---

List few advantages of stored procedure.

1026

---

What is db stored procedure?

943

---

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1195

---

What is sqlcmd?

1135

---

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

1023

---

What is the maximum rows in sql server table?

961

---

What is trigger in salesforce?

1051

---