Answer Posted / sai krishna

Select * from (Select Dense_Rank() over ( Partition by department_id Order by salary desc) as Rnk,E.* from HR.Employees E) where Rnk=1;

Why should I use oracle database?

978

---

Does facebook use oracle?

1021

---

What is Redo Log Buffer in Oracle?

1188

---

How to recover a dropped table in oracle?

1023

---

How to convert times to characters in oracle?

1014

---

Explain the truncate in oracle?

948

---

Oracle

2358

---

What is different types of joins?

1009

---

What is oracle latest version?

1084

---

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

1050

---

Explain the use of file option in exp command.

1117

---

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2442

---

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

1044

---

What is ASM (Automatic Storage Management) in Oracle?

1181

---

How will you write a query to get a 5th rank student from a table student_report?

1847

---