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 are actual and formal parameters?

1159

---

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1921

---

How to use select statement to count the number of rows in oracle?

1092

---

What is translate in oracle?

1141

---

What is a sub query and what are the different types of subqueries?

1173

---

How to bring a tablespace online?

1143

---

What are the different windows events activated at runtime ?

2945

---

Explain an exception and its types?

1135

---

What do you mean by cdb and pdb in oracle 12c?

1101

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2148

---

What are the uses of a database trigger?

1036

---

What are the ansi data types supported in oracle?

991

---

Explain implicit cursor.

1075

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1993

---

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2356

---