Answer / santhosh kandula

if u want select the second highest salary from the emp
table then u have to write query as

select max(salary) from emp where
salary < ( select max(salary) from emp )

Answer / ajitnayak

select e.*
from emp e
where rownum < 3
order by e.sal desc ;

How would you design a database for an online site, which would average a million hits a day?

0 Answers  

---

Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

0 Answers   TCS,

---

Explain about normal forms?

0 Answers  

---

explain detail about ftp in datastage?

0 Answers   IBM,

---

agregator gives one to many records or many to one record

1 Answers   IBM,

---

What are defaults? Is there a column to which a default can't be bound?

2 Answers  

---

What is the difference between a primary index and a secondary index? What is a duplicate data entry in an index? Can a primary index contain duplicates?

5 Answers   IBM,

---

Explain about relational operator join?

0 Answers  

---

Explain about the relational database?

0 Answers  

---

What are the three types of database design?

0 Answers  

---

Where is dbms used?

0 Answers  

---

How can I detect whether a given connection is blocked?

0 Answers  

---