Answer Posted / sudesh indore

select ( salary) as sal from employee ORDER by
salary DESC limit 2,1

------------
i hope that will help u thanx

Explain oracle instance.

686

---

What are the four Oracle system processes that must always be up and running for the database to be useable?

595

---

How to initialize variables with default values?

636

---

How to create an initialization parameter file?

543

---

What is recovery manager(rman) backup in Oracle?

629

---

---

What is system tablespace?

632

---

How to change program global area (pga) in oracle?

588

---

List out the components of logical database structure of oracle database.

585

---

How to connect to the server with user account: sys?

566

---

Why do we need oracle client?

511

---

Why do we use bulk collect in oracle?

571

---

How to create a table index?

568

---

What is background process in Oracle?

626

---

How to use "out" parameter properly?

634

---

How many types of segments in Oracle?

531

---