Answer Posted / ashutosh pandey

select sal from emp
where sal=(select min(sal) from emp
where sal>(select min(sal) from emp
where sal>(select min(sal) from emp);

What suggestions do you have to reduce the network traffic?

547

---

What happens to the data files if a tablespace is dropped?

576

---

How to create a new table in oracle?

591

---

Why should I use oracle database?

569

---

What is Virtual Private Database in Oracle?

623

---

---

Can multiple columns be used in group by in oracle?

546

---

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

593

---

In what script is snap$ created? In what script is the scott/tiger schema created?

2243

---

what is the scenario where you take the database to NoArchivelog mode?

1836

---

How can we force the database to use the user specified rollback segment?

557

---

What is the simplest tool to run commands on oracle servers?

517

---

What privilege is needed for a user to insert rows to tables in another schema?

560

---

What is Segment Advisor in Oracle?

669

---

can u plz provide me oca sql dumps please i need them

1466

---

Difference between inner join vs where ?

607

---