Answer / ruchi

you can use following query
select max(sal) from emp where sal<(select max(sal) from
emp);

Answer / tulasi

select * from emp x where 2=(select count(distinct sal)
from emp y where x.sal<=y.sal);

Answer / kd

select sal
from
(selec sal, row_number () over (order by sal desc nulls
last) as rnk
where rnk = 2;

Answer / smriti

select salary from(select rownum r,salary from details
order by salary desc)where rownum<2 and salary<(select max
(Salary) from details)

Answer / kavita

select max(sal) from emp where sal not in (select max(sal)
from emp)

Why do we need database?

0 Answers  

Excellent job opening with one of our client in Hyderabad About Client : It is an American e-commerce company based in Seattle, Washington, a leading online retailer of products that inform, educate, entertain and inspire.

1 Answers  

difference between generalisation,specialisation and aggregation? with examples.

0 Answers  

what is the difference between delete and truncate?

4 Answers  

Is it possible to open a cursor which is in a Package in another database?

1 Answers   CTS,

does pl/sql support “overloading”? Explain

0 Answers  

i have cleared the nic test...please send me the interview questions if anyone have them.... my email id is v84priya@gmail.com

0 Answers   NIC,

What is the difference between a delete command and truncate command?

0 Answers  

What is a concurrency problem in dbms?

0 Answers  

What are the main features of a database?

0 Answers  

Is file system a database?

0 Answers  

Explain the importance of database partitioning.

0 Answers