Answer Posted / harshal

Below query is written assuming table "employee" has a column called "salary".
select salary from (select salary from (select distinct(salary) from employee order by salary desc)where rownum<n) order by salary asc where rownum<1;

What is the template in sql?

914

---

What is inline table-value user-defined function?

1010

---

Explain partitioned view?

1018

---

How to backup encryption key ?

167

---

Why use identity in sql server?

1008

---

How to change the data type of an existing column with "alter table" statements in ms sql server?

929

---

Explain the difference between HTTP and HTTPS in database?

973

---

What is microsoft sql server?

911

---

How to Insert multiple rows with a single insert statement?

999

---

What is awe?

947

---

Name few of the dcl commands in sql?

951

---

What are the purposes and advantages stored procedure?

886

---

What do you mean by authentication modes in sql server?

1025

---

What is difference between cte and view?

854

---

what are the new features introduced in sql server 2000? : Sql server database administration

870

---