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 ;

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

2 Answers  

---

What is the maximum length of an extended property?

0 Answers  

---

How to use timestamp datatypes

0 Answers  

---

Explain the rollup operator?

0 Answers  

---

What are the 18 schemas?

0 Answers  

---

Explain the role of indexing in databases?

0 Answers  

---

Which data type cannot be used as a parameter in a udf?

0 Answers  

---

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

0 Answers  

---

What are the disadvantages of cursors? How can you avoid cursors?

2 Answers  

---

Explain about post-relational databases?

0 Answers  

---

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

0 Answers  

---

On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

0 Answers  

---