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

What is dictionary cache ?

2 Answers  

---

Explain the use of record option in exp command.

0 Answers  

---

How to speed up webrick?

0 Answers  

---

Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)

4 Answers   Infosys,

---

Can we create more than one constraint to column ?

6 Answers  

---

---

Whatz the main diff between Subquery and a Join

14 Answers   Oracle, Zeta Interactive,

---

find out first highest salary?

10 Answers   Verinon Technology Solutions,

---

what is foreign key?

5 Answers  

---

How to lock and unlock a user account in oracle?

0 Answers  

---

acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account

2 Answers   Polaris,

---

What is the difference between column level constraints and table level constraints?

14 Answers   IBM, TCS,

---

what is trigger?

6 Answers   Oracle,

---