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)

What is compound key?

0 Answers  

Is it possible to declare or create a cursor for update of table? If no tell me why?

0 Answers  

What is Distributed database ?

2 Answers  

What is the purpose of queries in a database?

0 Answers  

What are Stored Procedures and When would we Use Them?

1 Answers  

What is delimiter in dbms?

0 Answers  

What is the easiest database to learn?

0 Answers  

Why is foreign key used?

0 Answers  

What are different types of joins in the sql?

0 Answers  

Difference between data and information, and how are they related in a database?

0 Answers   Huawei,

How do I create a database?

0 Answers  

Can a DIALOG WINDOW have scroll bar attached to it ?

1 Answers