Answer Posted / anish tuladhar

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

what is a schema in sql server 2005? : Sql server database administration

959

---

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

888

---

How many levels of sp nesting is possible?

999

---

What is explicit mode in sql server?

1019

---

you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

922

---

Explain “row_number()” in sql server with an example?

950

---

What are the requirements for sql server 2016?

852

---

What is side by side migration in sql server?

1023

---

What are the advantages of using a stored procedure?

942

---

where can you add custom error messages to sql server? : Sql server administration

1048

---

Explain primary key, foreign key and unique key?

936

---

How do I start and stop sql server?

967

---

What is the syntax to execute the sys.dm_db_missing_index_details?

970

---

Tell about MOM Tool(Microsoft Operator Manager)?

1855

---

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

950

---