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

Explain the microsoft sql server delete command? : SQL Server Architecture

0 Answers  

---

How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?

2 Answers   Genpact,

---

What is default constraint?

0 Answers  

---

What is the difference between Userdefined function and stored procedure? Explain and give the example also

5 Answers  

---

What is a primary index?

0 Answers  

---

Is sql server free?

0 Answers  

---

What are the extra roles available in msdb? : sql server security

0 Answers  

---

How to get number of days in a given year?

4 Answers   ADP,

---

What is the use of DBCC commands?

4 Answers   NA,

---

How to create a Master database in SQL server ?

0 Answers   MCN Solutions,

---

Anyone please explain me the concept of Serialization?

3 Answers  

---

Why union all is faster than union?

0 Answers  

---