Answer Posted / shivaprasad

select distinct top 1 Salary from(select distinct top 3
Salary from Employee order by Salary DESC)temp order by
Salary;

What is an oracle database?

610

---

Can we convert a date to char in oracle and if so, what would be the syntax?

548

---

What is a oracle database?

605

---

How data locks are respected in oracle?

571

---

How can you merge two tables in oracle?

565

---

---

What happens if variable names collide with table/column names?

583

---

What is clustered table in Oracle?

641

---

what is the difference between functional dependecy and multilevel dependency?

1989

---

How many types of tables supported by oracle?

578

---

How to select all columns of all rows from a table in oracle?

588

---

How to get last row id?

554

---

Explain about your project and its relation to the current job position you are applying to?

538

---

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

608

---

In oracle there is column command, how will you explain that?

547

---

Is postgres faster than oracle?

557

---