Answer Posted / deven

<font color="Green" >This is long method but it works</color>

<font color="red" >step 1(this will make salary in
ascending order)</color>

<font color="blue" >create index Ind_sal on emp(salary)</color>

<font color="red" >step 2(to calculate Nth highest salary
where N=1,2,3,4.....)</color>

<font color="blue" >select distinct top N salary from emp
except
select distinct top N-1 salary from emp
</color>

<font color="red" >in some databases 2nd step may be</color>
<font color="blue" >
select distinct top N salary from emp
minus
select distinct top N-1 salary from emp</color>

List out the different types of locks available in sql server?

931

---

When to use Inner join & when to use subquery?

1078

---

Can you pass expressions to function parameters?

1030

---

What stored by the tempdb ? : sql server database administration

1003

---

How can I track the changes or identify the latest insert-update-delete from a table?

912

---

What is attribute hierarchy? : sql server analysis services, ssas

960

---

Can we use max in where clause?

876

---

What is extent? Types of extents?

1086

---

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

918

---

Write a query for primary key constraint with identity key word?

971

---

How do I manually uninstall an instance of sql server 2016?

960

---

How can I check that whether automatic statistic update is enabled or not?

984

---

How do you make a trace?

951

---

what are the core components of SSRS?

121

---

What is tabulation?

896

---