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>

What are the difference between clustered and a non-clustered index?

1091

---

What is in place upgrade in sql server?

1096

---

Describe how to use the linked server?

1204

---

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1184

---

How to count duplicated values in a column in ms sql server?

1171

---

Explain the dirty pages?

1054

---

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

1060

---

What is the use of sql profiler in sql server 2012?

946

---

What are the different acid properties?

1122

---

How you can add messages to the nt event log from within a stored procedure?

1140

---

Which is better statement or preparedstatement?

984

---

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

113

---

How check triggers in sql server?

1056

---

Explain boyce and codd normal form(bcnf)?

1016

---

Can sub report data source be different from that of the parent report?

149

---