Answer / padiya hiten

select * from emp e1 where (3=(select count(distinct
(e2.sal))from emp e2 where e2.sal>=e1.sal));

Answer / sumeet

select min(sal) from emp where sal in (select top 2 sal from
emp order by sal desc);

Answer / shachindra pandey

proc sql;
select id,name,population from populations where
population=(select max(population) from
populations
where population < (select max(population) from
populations));


quit;

Answer / tejinder

select salary from emp order by salary desc limit 0,1;

Answer / kiran

select max(empsal) from emp where rownum<=2

Can Multiple instances be run on Single Machine???

3 Answers  

---

can u call user defined functions in select statements

2 Answers  

---

How index is implemented in oracle database?

0 Answers  

---

What is an oracle tablespace?

0 Answers  

---

What is the difference between PFILE and SPFILE in Oracle?

0 Answers   MCN Solutions,

---

---

What are the composite date types in oracle?

6 Answers   HCL,

---

The join defined by the default data link is an outer join yes or no ?

1 Answers   Oracle,

---

T1: T2 A X--- this is updated record B B like this T1 table having no.of records updated. write a query"retrive updated record from T2"

2 Answers   Cognizant,

---

What is tns name?

0 Answers  

---

List the various oracle database objects?

0 Answers  

---

How to save query output to a local file?

0 Answers  

---

Give the Types of modules in a form?

1 Answers  

---