Answer Posted / yaseen syed

select *
from
(select empno,ename,sal,rank() over(order by sal desc)
ranking from emp)
where ranking=2;

and u can find the nth highest sal by replacing 2 by your
number

Explain table?

1123

---

What is a schema in oracle?

1026

---

How is it different from a normal table?

1041

---

What is meant by raw datatype?

1071

---

what is insert all statement in sql

6539

---

What is the disadvantage of User defind function?

2304

---

Why should I use oracle database?

1002

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2974

---

What is the difference between sharding and replication?

1062

---

How do we display rows from the table without duplicates?

979

---

State the various uses of dbcc command?

1065

---

What are the different types of failures that occur in Oracle database?

1076

---

What happens if recursive calls get out of control?

1088

---

How would you change old and new values in an insert, delete and update triggers?

1029

---

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

2006

---