Answer Posted / rakhi

SELECT *
FROM (
SELECT employee_id, last_name, salary,
RANK() OVER (ORDER BY salary DESC) EMPRANK
FROM employees)
WHERE emprank = 2;

What is enter substitution variable in oracle?

1028

---

Is java required for oracle client?

971

---

How can we delete duplicate rows in a table?

954

---

How to retrieve values from data fields in record variables?

1088

---

How do I call oracle stored procedures that take no parameters?

1088

---

What is a snapshot log?

987

---

Is oracle the best database?

950

---

What is a read only transaction in oracle?

998

---

what is reindexing?

1649

---

Explain the use of Merge statement in oracle 11g

1011

---

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1633

---

How to write an inner join with the where clause in oracle?

1030

---

What are the differences between char and nchar in oracle?

1066

---

candidate key is subset of super key but not vice-verse explain

2057

---

Can a formula column referred to columns in higher group ?

2490

---