Answer Posted / anish tuladhar

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

How efficient you are in oracle and SQL server?

1163

---

How to loop through returning rows?

1039

---

Explain few examples of stored procedure over triggers?

1046

---

Does windows server 2016 come with sql server?

939

---

Explain difference between cross join and full outer join?

1012

---

Does an index slow down updates on indexed columns?

979

---

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

1138

---

What do you understand by check constraint in sql server?

950

---

Explain what is row_number function?

1046

---

How to connect sql server management studio express to sql server 2005 express?

1049

---

What is compression - row-level and page-level compression?

921

---

How can I get data from a database on another server?

1001

---

What is the use of nvl work?

1009

---

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

970

---

How many triggers are possible per table?

1104

---