Answer Posted / gaurav

try this

select max(salary)
from employees
where salary < (select max(salary)
from employees
where salary < (select max(salary)
from employees));

Can we connect to ORACLE db using Windows Authentication?

1308

---

What is the relation of a user account and a schema?

1176

---

How to create a table index in oracle?

1186

---

What is the dynamic sql in oracle?

1136

---

Explain the dml?

1051

---

How to shutdown your 10g xe server?

1206

---

What are the uses of linked server and explain it in detail?

1118

---

How to define a procedure inside another procedure?

1069

---

Explain oracle’s server parameter file.

1041

---

How to sort output in descending order in oracle?

1105

---

How to import one table back from a dump file?

1087

---

What's dateware house and what's clustor with practicle example

2237

---

How to write a query with a left outer join in oracle?

1126

---

if you ctreate table identity

2430

---

What is tns entry?

1237

---