Answer Posted / arun

select distinct (a.salary) from employees a
where &N = (select count (distinct(b.salary))
from employees b where a.salary <= b.salary);

What are sql objects?

1075

---

what is a tablespace? : Sql dba

1051

---

What are the features of pl sql?

1067

---

Does sql between include endpoints?

1009

---

Why we use cross join?

952

---

What are the sql commands?

1177

---

What is the basic form of sql query?

943

---

what are the properties and different types of sub-queries? : Sql dba

1034

---

how to use 'mysql' to run sql statements? : Sql dba

1051

---

Is it possible to read/write files to-and-from PL/SQL?

1101

---

What is the largest value that can be stored in a byte data field?

1012

---

What is the difference between the conventional and direct path loads? : aql loader

1399

---

what are the performance and scalability characteristics of mysql? : Sql dba

996

---

What is difference between joins and union?

1124

---

How do you write an index?

965

---