Answer Posted / raghav

select * from (
select Name,
Salary,
Dept,
Rank()over (order by salary desc) RANK
from Employee)
where RANK = 3

What is backup in Oracle?

568

---

How to apply filtering criteria at group level in oracle?

584

---

How can I introduce multiple conditions in like operator?

553

---

How many types of database triggers exist?

575

---

 What are the oracle DML commands possible through an update strategy?

580

---

---

What is the max number of columns in an oracle table?

512

---

What is a Garbage Collection? and what is full recursive Garbage collection?

2387

---

What is a server parameter file in oracle?

589

---

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

1701

---

How translate command is different from replace?

543

---

How do I reset a sequence in oracle?

592

---

What is a user account in oracle?

627

---

What is the usage of merge statement?

670

---

Can I create users through internet explorer in oracle 10g?

567

---

How do I spool to a csv formatted file using sqlplus?

545

---