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);

Explain the function of optimizer in oracle?

0 Answers  

---

What are the advantages of oracle 12c?

0 Answers  

---

SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.

2 Answers   Cognizant,

---

How to run the anonymous block again?

0 Answers  

---

Explain integrity constraint?

0 Answers  

---

1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.

1 Answers   Wipro,

---

What is enter substitution variable in oracle?

0 Answers  

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

0 Answers   IBM,

---

Difference between varchar and varchar2 data types?

0 Answers  

---

What is a heap related to database ?

1 Answers   TCS, University of Edinburgh,

---

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

0 Answers  

---

What is a sub query? What are its various types?

0 Answers  

---