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 understand by the analysis services in sql server?

0 Answers  

---

What do you mean by collation recursive stored procedure?

0 Answers  

---

I have a table Events Events containing cardno,time,id,name- -each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers  

---

What is a scheduled job or what is a scheduled task?

0 Answers  

---

how to change column into row in sql

4 Answers   ESS,

---

Diffrences between sql server 2000 vs 2008

0 Answers   TCS,

---

What is a trigger?

7 Answers  

---

how to delete duplicate rows in sql server2005

7 Answers   Cisco, CTS, HCL, IBM,

---

how to determine the service pack currently installed on sql server? : Sql server database administration

0 Answers  

---

What does truncate do?

0 Answers  

---

What is service broker? : sql server database administration

0 Answers  

---

What is a rownum?

0 Answers  

---