Answer Posted / santhosh

;with result as
(
--use dense_rank instead of row_number or rank
select salary, DENSE_RANK() over (order by salary desc) as denserank
from Employees
)
select top 1 * from result
where denserank = 4

What is difference between global temporary tables and local temporary tables?

1239

---

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1112

---

why would you use sql agent? : Sql server database administration

1221

---

What is the difference between SQL notification and SQL invalidation?

1198

---

What is normalization? What number of normalization shapes are there?

1112

---

How many columns can exist together per table?

1161

---

Can we insert data into a view?

1143

---

what is blocking? : Sql server database administration

1047

---

What is a trace frag? Where do we use it?

1104

---

Write SQL queries on Self Join and Inner Join.

1160

---

What is the bookmark lookup and rid lookup?

998

---

When is update_statistics command used?

1052

---

What are indexes in ms sql server?

1065

---

What are sp_configure commands and set commands?

1024

---

List out some of the requirements to set up a sql server failover cluster?

1034

---