Answer Posted / lokanath

select * from emp a where 2 > (select count(distinct sal)
from emp b where b.sal > a.sal)
or else use Top Window functions (or) Analatical functions
select * from
(
select empno,ename,sal,rank() over (order by sal desc)
test from emp
)
where test <= 2

What is oracle database client?

1032

---

Explain how are indexes update?

1064

---

How do we get field details of a table?

978

---

What is define in oracle?

1060

---

How to write a query with a right outer join in oracle?

1168

---

How would you change old and new values in an insert, delete and update triggers?

1020

---

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2341

---

Explain implicit cursor.

1027

---

What are temporal data types in oracle?

1121

---

Query to retrieve record for a many to many relationship ?

2518

---

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1999

---

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1985

---

Can sub procedure/function be called recursively?

1001

---

Is java required for oracle client?

996

---

What is the implicit cursor in oracle?

1105

---