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>

How to use group functions in the select clause in ms sql server?

1065

---

What is executereader?

963

---

Can you name a few encryption mechanisms in sql server?

951

---

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1755

---

What are data regions?

140

---

How does using a separate hard drive for several database objects improves performance right away?

941

---

What is an execution plan?

1158

---

Tell me what is difference between view and materialized view?

947

---

What are the different type of replication in sql server?

988

---

How do I debug a stored procedure in sql server?

1118

---

What is ddl command?

990

---

Which are new data types introduced in sql server 2008?

1057

---

how you can move data or databases between servers and databases in sql server? : Sql server administration

977

---

What type of Index will get created after executing the above statement?

1106

---

Explain the difference between HTTP and HTTPS in database?

1042

---