Answer Posted / rakhi

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

Can we call procedure inside function in oracle?

1162

---

State all possible different index configurations a table can possibly have?

1114

---

List out the types of joins.

1254

---

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2257

---

Is insert autocommit in oracle?

1138

---

What is a trace file and how is it created in oracle?

1153

---

can u plz provide me oca sql dumps please i need them

2004

---

What is query image?

1025

---

What is the difference between "as" and "is" in an oracle stored procedure?

1061

---

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

1801

---

What happens if the update subquery returns multiple rows?

1180

---

Is there any function in oracle similar like group_concat of mysql?

1119

---

What is a database schema in oracle?

1164

---

What are privileges and grants?

1115

---

Please explain oracle data types with examples?

1134

---