Answer Posted / arungkd

Hey dudes ,

i have worked out this question and got the Answer.... here
it is given below...

SELECT min(income) AS salary FROM [user] WHERE income in
(SELECT DISTINCT top 3 income FROM [user] order by income
desc )

What is the order of defining local variables and sub procedures/functions?

1009

---

What is recovery manager(rman) backup in Oracle?

1127

---

What are the major difference between truncate and delete?

988

---

How to view all columns in an existing table?

878

---

How to list all tables in your schema?

993

---

Explain the features of oracle?

991

---

what is difference between sql plus and sql*plus? (not sql and sql plus).

3818

---

How to omit columns with default values in insert statement in oracle?

1003

---

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1328

---

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2000

---

How to write numeric literals in oracle?

1130

---

what is the scripts in data base?

2082

---

How many types of segments in Oracle?

1014

---

How to create tables for odbc connection testing?

1011

---

How to use subqueries in the from clause in oracle?

1048

---