Answer Posted / amitabh sharma

Here are 2 queries for finding 3rd highest salary:

select * from emp e
where 3 = (select count(sal) from emp
where e.sal < sal);


SELECT * FROM
(
SELECT Ename, SAL, dense_Rank() OVER (ORDER BY SAL DESC )
RANKNEW FROM EMP)
WHERE RANKNEW = 3

Regards,
Amitabh Sharma

what happened to the global index when I truncate the data in one of the partition?

2066

---

What is the difference between count (*), count (expression), count (distinct expression)?

1046

---

How to define an anonymous procedure with variables?

1242

---

Explain the blob datatype?

1125

---

What is raw datatype?

1190

---

What are the oracle built-in data types?

1138

---

When do you get a .pll extension in oracle?

1193

---

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1161

---

What is logical backup in oracle?

1085

---

Explain the characteristics of oracle dba?

1176

---

Explain the truncate in oracle?

1013

---

Explain the use of grant option in exp command.

1112

---

What are the system predefined user roles?

1100

---

Why do we use bulk collect in oracle?

1108

---

What is the quickest way to export a table to a flat file?

1012

---