Answer Posted / sanil

select first_name,salary from employees a
where (select count(distinct(salary)) from employees aa
where a.salary<=AA.SALARY) = &n;

How to get execution statistics reports on query statements?

1009

---

What does sharding mean?

947

---

Explain parameter file in oracle.

974

---

What is oracle thin client?

975

---

What are data pump export and import modes?

1019

---

How to increment dates by 1 in oracle?

992

---

How to define a variable to match a table column data type?

938

---

How to use attributes of the implicit cursor in oracle?

951

---

What are the various constraints used in oracle?

993

---

How to initialize variables with default values?

1161

---

What is Undo Management Advisor in Oracle?

1042

---

What are the execution control statements?

1018

---

What is the fastest query method to fetch data from the table?

1295

---

What is meant by raw datatype?

1005

---

What do you know about normalization? Explain in detail?

882

---