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 1nf 2nf 3nf in dbms?

0 Answers  

What is 2nf in the dbms?

0 Answers  

please explain Nomalization in dbms?

5 Answers  

Can we save image in database?

0 Answers  

What are the differences between a dbms and rdbms?

0 Answers  

What do you understand by the terms entity, entity type, and entity set in dbms?

0 Answers  

What is the difference between delete and truncate command in dbms?

0 Answers  

how to restore particular schema from rman full backup?

0 Answers   HCL,

What is authorization and integrity manager?

0 Answers  

What is database management system with example?

0 Answers  

What are the Different Types of Joins and How do They Work?

1 Answers  

What are partitions in database?

0 Answers