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 a data dictionary and how can it be created?

1240

---

How to delete all rows a table in oracle?

1119

---

How to work with data objects interactively?

1043

---

Explain the truncate in oracle?

1013

---

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2523

---

How do I limit the number of oracle database connections generated by weblogic server?

1117

---

What is rowid and rownum in oracle?

1070

---

Are truncate and delete commands same? If so why?

1204

---

Is there an oracle sql query that aggregates multiple rows into one row?

1032

---

Difference between oracle's plus (+) notation and ansi join notation?

1160

---

How translate command is different from replace?

1142

---

How to compare dates in oracle sql?

1162

---

Please explain drop constraint oracle?

1160

---

How to calculate date and time differences in oracle?

1099

---

What is define in oracle?

1112

---