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 is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

986

---

what information is maintained within the msdb database? : Sql server administration

980

---

How to connect php with different port numbers?

1088

---

What is acid db?

889

---

What is cube dimension? : sql server analysis services, ssas

1011

---

What happens if you are trying to access a schema not owned by you?

968

---

how to overcome kernel isssues

1629

---

List out some of the requirements to set up a sql server failover cluster?

1034

---

Explain what are commit and rollback in sql?

935

---

Which are new data types introduced in sql server 2008?

1054

---

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1142

---

What is the use of group by clause?

944

---

What is the sql case statement used for?

1104

---

Explain the properties of subqueries in sql server?

1083

---

How to install sql server 2005 express edition?

1125

---