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

query optmization techniques and quwry analyser+projects+ppts

0 Answers  

Can we create index on views?

19 Answers   CTS, Syntel, TCS,

What is Oracle table?

1 Answers  

5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.

6 Answers   Wipro,

What is oracle rowcount?

0 Answers  

material view and view disadvantages?

0 Answers  

State the difference between a primary key and foreign key?

0 Answers  

definition of cluster and non-clustered index?

0 Answers   CSS,

Which Oracle App Is Most Popular One ?

3 Answers  

What to do if dba lost the system password?

0 Answers  

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

0 Answers  

How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?

2 Answers   Infosys,