Answer / lakshmi

select sal from emp
where sal = (max(sal) from emp
where sal < (max(sal) from emp
where sal < (max(sal) from emp)));

Answer / ashutosh pandey

select sal from emp
where sal=(select min(sal) from emp
where sal>(select min(sal) from emp
where sal>(select min(sal) from emp);

Whether Oracle satisfy more codd rules or db2 satisfy more codd rules? How meny of each can satisfy ? Please answer me. Advance thanks

2 Answers   IBM,

---

What is Parallel Server ?

3 Answers  

---

What is the difference between translate and replace?

0 Answers  

---

where we have to use ON clause and where we have to use USING clause in JOINS

2 Answers  

---

when a grant option is encountered for a table EMP to a peer sitting beside you who has already having the table of that name (EMP), then what is the result?

2 Answers  

---

What is snapshot is too old? Give and example for better understand.

0 Answers   TCS,

---

How to define an anonymous procedure without variables?

0 Answers  

---

what is the use of composite key constraint?

2 Answers  

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

0 Answers   Sierra Atlantica,

---

what is meant by magic query

0 Answers  

---

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

0 Answers   Goldman Sachs,

---

Can a View based on another View ?

3 Answers  

---