Answer / anish tuladhar

select
distinct salary
from
(
select
DENSE_RANK() over(order by salary desc) as rnk,
salary
from
employee
) a
where
rnk = 4

Answer / prabhjeet singh sethi

select * from
(select rank(salary) over (partition by employee order by salary desc) as top_salary, employee from table
group by employee)
where top_salary = 4

Answer / icedrop

 select top 1 salary from (select distinct top 4 Salary from tablename order by salary desc ) result order by salary 

Answer / 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 do you mean by stored techniques? How would we use it?

0 Answers  

---

Where are sql server user names and passwords stored in sql server?

0 Answers  

---

Explain indexed views and partitioned view with their syntax.

0 Answers  

---

What are the four main query statements?

7 Answers   Wipro,

---

tell me the disaster recovery plan

0 Answers   Microsoft,

---

What are a scheduled jobs or what is a scheduled tasks?

0 Answers  

---

How can you check the level of fragmentation on a table?

0 Answers  

---

What is serializable?

0 Answers  

---

What is default port number for sql server 2000?

0 Answers  

---

Explain the various types of concurrency problem?

0 Answers  

---

What do you understand by SQL*Net?

0 Answers   Tech Mahindra,

---

How to download and install sql server 2005 books online?

0 Answers  

---