Answer Posted / avnish srivastava-test engg fc

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

Explain oracle data types with examples?

583

---

what are archived logs?

1721

---

What is an oracle user role?

579

---

How to create a new table by selecting rows from another table?

561

---

Does oracle database need java?

532

---

---

How do I uninstall oracle 11g?

572

---

What is query image?

590

---

What does sharding mean?

549

---

Point out the difference between user tables and data dictionary?

550

---

How to create tables for odbc connection testing?

501

---

what is the difference between restoring and recovering?

566

---

What happens to the current transaction if the session is ended?

540

---

Is it possible to insert comments into sql statements return in the data model editor ?

2076

---

How to see free space of each tablespace?

598

---

How can we delete duplicate rows in a table?

570

---