Answer / madhavi

SELECT sal
FROM (SELECT sal, RANK() OVER(ORDER BY sal DESC) AS rnk
FROM emp)
WHERE rnk IN (1,2,3);

Answer / ajit

select distinct *
from (select e.*,dense_rank()over(order by sal desc) rn from emp e)
where rn in (1,2,3);

Answer / annada

SELECT e.lastname,e.salary FROM employees e
WHERE 1=(SELECT count(*) FROM employess s
WHERE s.salary>e.salary

I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.

6 Answers  

---

What is mean by Program Global Area (PGA) ?

9 Answers   Bajaj,

---

Differentiate between translate and replace?

0 Answers  

---

how to insert the image in table

2 Answers  

---

How to create an oracle database?

0 Answers  

---

What is a Shared SQL pool ?

2 Answers  

---

what is the difference between dbms and rdbms?

3 Answers   Oracle,

---

what are the things that you consider while creating indexes on partitioning tables?

1 Answers  

---

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

0 Answers   IBM,

---

How do we switch from init.ora file to asp file?

2 Answers  

---

How to set a transaction to be read only in oracle?

0 Answers  

---

What is PL/SQL ?

3 Answers  

---