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 do I connect to oracle?

1027

---

How to export data with a field delimiter?

1037

---

What is the relationship among database, tablespace and data file?

986

---

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

2019

---

Can we convert a date to char in oracle and if so, what would be the syntax?

1012

---

What are the database administrators utilities available?

1027

---

ABOUT IDENTITY?

2053

---

How do you find current date and time in oracle?

1045

---

How to create a temporary table in oracle?

1267

---

What is an anonymous block?

1236

---

What do you mean by cdb and pdb in oracle 12c?

1059

---

How to calculate date and time differences in oracle?

1038

---

How do I know if oracle client is installed on windows?

1020

---

Can a formula column referred to columns in higher group ?

2498

---

How to add another datafile to a tablespace?

1039

---