Answer Posted / mihir nasikkar

Here n is 3


SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary

How to insert multiple rows with one insert statement in oracle?

570

---

what is port in oracle? how is it related to database application.

1438

---

How do I connect to oracle?

562

---

What is a subquery in oracle?

578

---

What is the difference between hot backup and cold backup in oracle?

520

---

---

Why should I use oracle database?

569

---

How to check the oracle tns settings?

573

---

20. Using a set operator, display the client number of all clients who have never placed an order.

1797

---

What is an oracle database?

612

---

How to get a list of all user accounts in the database?

616

---

What to do if dba lost the system password?

597

---

Explain alias?

711

---

Explain the blob datatype?

618

---

Explain the use of indexes option in imp command.

566

---

Explain what does a control file contain?

607

---