Answer Posted / sapna rawal

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

n=3.In this case.

Why packages are used in oracle?

1066

---

Explain what does a control file contain?

1099

---

what is the difference between data migration and production migration.

2346

---

What do you mean by group by clause?

1045

---

How to select some columns from a table in oracle?

1095

---

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2209

---

How do you tell what your machine name is and what is its IP address?

2096

---

Explain a private synonyms?

1039

---

How does oracle handle read consistency?

1097

---

What language does oracle use?

1103

---

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4174

---

How to grant create session privilege to a user in oracle?

1002

---

What is a trigger oracle?

1088

---

Is there any function in oracle similar like group_concat of mysql?

1053

---

How to view existing locks on the database?

1053

---