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 triggers in sql?

0 Answers  

---

what is a join and explain different types of joins? : Sql server database administration

0 Answers  

---

What is the cpu pressure?

0 Answers  

---

What is the difference between truncate and delete statement?

6 Answers   CarrizalSoft Technologies, CTS,

---

What is thr feature of change data capture?

0 Answers  

---

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

0 Answers  

---

what is a self join? : Sql server database administration

0 Answers  

---

How to create an index on an existing table in ms sql server?

0 Answers  

---

How to delete duplicate rows?

0 Answers  

---

what is the difference between procedure and function.

4 Answers   Thomson,

---

When columns are added to existing tables, what do they initially contain?

0 Answers  

---

If the job running very slow what is the action you do

0 Answers  

---