Answer Posted / ajit

SQL QUERIES FOR FINDING Nth HIGHEST SALARY

SELECT DISTINCT (a.salary) FROM EMPLOYEES A WHERE &N = (SELECT COUNT (DISTINCT (b.salary)) FROM EMPLOYEES B WHERE a.salary<=b.salary);

What are operators in oracle?

1055

---

How to create a table index in oracle?

1134

---

Explain the function of optimizer in oracle?

1143

---

What is SQL Tuning Advisor in Oracle?

1181

---

How to save query output to a local file?

1026

---

What is the purpose of save points in oracle database?

1119

---

What is difference between cartesian join and cross join?

1088

---

How to do a full database export?

1111

---

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2292

---

How do we get field details of a table?

978

---

What is not equal to in oracle?

1003

---

Explain the use of record length option in exp command.

1067

---

Why oracle is used?

1058

---

How many memory layers are in the oracle shared pool?

1184

---

What is merge statement used for?

1024

---