write a query to Find the Maximun second value in table?

Answer Posted / smriti

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

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the meaning of flat file database?

556


What is openedge workgroup rdbms?

675


What is rdbms and its types?

549


What are the examples of database management system?

502


Why is group-clause used?

628






Does google have a database program?

583


Explain snapshot replication.

602


What is denormalization and why would someone consider doing so?

519


What is the full form of rdbms?

568


What is bcnf?

666


1)How to check tablespace utilization? 2)what are the RMAN CLONING STEPS? 3)what is standby database? 4)what is difference between standalone database and target database? 5)How to backup the standalone database? 6)tell about the ubgrade steps? 7)How to apply the pathes?

1882


Is access a database?

570


What is db flush?

569


What are the functions of rdbms?

578


What does you mean by s4 super key?

664