Answer Posted / sudheer

Guys Few of you have submitted an optimal query.

select distinct sal from emp A where 3 = (select count(sal)
from emp B where a.sal > b.sal)

However the integer 3 will not give the third highest salary
as expected. Point should be noted that the row starts with
zero.

so the actual result will the fourth highest salary with the
above query.

How to open and close an explicit cursor in oracle?

1099

---

What is a dead lock in oracle?

1177

---

What is oracle open database communication (odbc)?

1086

---

What is a database table in oracle?

1071

---

State and explain the different types of data models?

995

---

How to start an oracle instance?

1076

---

Please explain oracle left join with an example?

1095

---

What is sequence?

1136

---

What is data file?

1152

---

Explain an extent?

1158

---

What are a cluster and non-cluster index?

1065

---

How to use group functions in the select clause using oracle?

1134

---

What is a schema in oracle?

1067

---

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

1046

---

What do you mean by group by clause?

1094

---