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;

Explain the properties of sub-query in sql server?

726

---

Explain indexed views?

743

---

Explain the functionalities that views support?

853

---

How to test odbc dsn connection settings?

705

---

How can we determine what objects a user-defined function depends upon?

694

---

---

What do you understand by the denormalisation?

711

---

What is meant by referential integrity?

749

---

Which is the main third-party tool used in sql server?

664

---

What is mean by dml?

734

---

What is federation member?

111

---

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1708

---

What is implicit cursors?

747

---

How sql server executes a statement with nested subqueries?

702

---

What are the benefits and tasks of object explorer? : sql server management studio

799

---

What is change data capture (cdc) in sql server 2008?

755

---