Answer Posted / suresh kumar

Hi every body,

I give the standard format Query for this type of top most
and who are the top n people in the organization like that

If we take EMP table

Select * from EMP A where &n= (select count (distinct
(sal)) from EMP B where B.sal>A.sal)

If we give n value 1 or 2 or 3….etc then we gets top one,
top second, and top third person details.

This same query can we use top n people who are earning
maximum salaries in the Organization

Select * from EMP A where &n> (select count (distinct
(sal)) from EMP B where B.sal>A.sal)

What is columnar storage what is the advantage?

1012

---

Explain what are clusters?

1070

---

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2924

---

Name the three major set of files on disk that compose a database in Oracle?

1085

---

How to use group functions in the select clause using oracle?

1042

---

Explain mutating triggers.

992

---

Can we insert data in view oracle?

981

---

How to connect to oracle using service name instead of sid?

977

---

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

1692

---

How to create an oracle database?

992

---

What do database buffers contain?

981

---

What is the difference between sharding and partitioning?

953

---

What is an oracle cursor variable?

1028

---

What happens if recursive calls get out of control?

1034

---

ABOUT IDENTITY?

2019

---