Answer Posted / tejasvita dhuri

select id,salary from (select id,salary,ROW_NUMBER()over (order by salary desc) as rowcol from emp)A
where A.rowcol=2

What are the advantages of stored procedure?

1005

---

Is sql between inclusive?

1133

---

Is full outer join same as cross join?

970

---

what are the differences between require and include, include_once and require_once? : Sql dba

1023

---

What is the difference between explicit and implicit cursors in oracle?

1069

---

What is a unique key?

1056

---

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1209

---

What are the different types of triggers?

1137

---

what is uncommittable transactions? : Transact sql

996

---

What are the set operators in sql?

1073

---

What is using in sql?

1094

---

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

961

---

discuss about myisam index statistics collection. : Sql dba

952

---

What is spool?

1055

---

Define union, minus, union all, intersect ?

1007

---