Answer Posted / sumit wadhwa

for max

select a.sal
from emp a
where 1=(select distinct(count(b.sal))
from emp b
where a.sal<=b.sal);

for second max

select a.sal
from emp a
where 2=(select distinct(count(b.sal))
from emp b
where a.sal<=b.sal)

What is a data dictionary and how can it be created?

1055

---

How to get execution path reports on query statements?

927

---

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2300

---

What is the difference between "as" and "is" in an oracle stored procedure?

932

---

Explain about achiever in sql?

979

---

How to convert csv to table in oracle?

921

---

Explain self joins in oracle?

949

---

How to use select statement to count the number of rows in oracle?

986

---

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

954

---

How to define a variable to match a table column data type?

937

---

Does oracle charge for java?

1006

---

What are the general rules on data consistency?

957

---

Please explain compound trigger in oracle?

993

---

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

1979

---

How do I find the database name in oracle?

979

---