Answer Posted / ayush sharma

select sal from (select distinct sal from emp order by desc)
where rownum <=n minus select sal from(select distinct sal
from emp order by desc) where rownum<=n-1;

What are the restraints imposed on the table design by a merge replication?

982

---

Describe different Processing Modes offered by SSRS?

232

---

Do you know concepts and capabilities of sql server?

1005

---

Explain how to integrate the ssrs reports in application?

943

---

What are acid properties of transaction?

894

---

How to identify current user in ssrs report?

390

---

What are relationships and mention different types of relationships in the dbms

911

---

Is it possible to create trigger on views?

934

---

What is a partition key?

884

---

What is the osql utility?

909

---

Can you index views?

852

---

Can group by be used without aggregate functions?

856

---

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1058

---

How to delete duplicate records based on single column from a table?

996

---

What is the maximum row of a size?

953

---