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

Explain the difference between replace() and translate() functions in oracle?

973

---

What is the usage of merge statement?

1094

---

Which is better Oracle or MS SQL? Why?

4819

---

Name the various constraints used in oracle?

968

---

How to list all tables in your schema?

989

---

What are the oracle differences between nvl and coalesce

1064

---

How do I connect to oracle?

974

---

What is java oracle used for?

963

---

What is a trigger and what are its types in oracle?

996

---

What are the numeric comparison operations?

1050

---

What are the differences between char and nchar in oracle?

1020

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2040

---

What do database buffers contain?

956

---

Explain the use of file option in exp command.

1078

---

What happens if recursive calls get out of control?

997

---