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 join two tables in a single query using oracle?

1054

---

How to test null values?

1156

---

How do I learn what codesets are available in oracle?

1080

---

How to install oracle odbc drivers?

1145

---

What is oracle in java?

1019

---

How to pass a parameter to a cursor in oracle?

1231

---

What are the differences between lov and list item?

1147

---

Can I create users through internet explorer in oracle 10g?

1158

---

What are the oracle built-in data types?

1138

---

What is oracle join syntax?

1063

---

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2505

---

How to assign a table row to a record variable?

1094

---

How to create additional tablespaces for an new database?

1079

---

How to create an oracle database?

1104

---

What is the difference between pre-select and pre-query?

1303

---