how to find out second largest value in the table

Answer Posted / sudhakara reddy k

select max(sal) from emp where
sal<(select max(sal) from emp);

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to execute a stored program unit?

578


Explain the use of analyse option in exp command.

584


What is dynamic proxy?

547


What are the extensions used by oracle reports?

571


How to define a sub function?

660






How to use "startup" command to start default instance?

540


How to open a cursor variable?

602


What are group functions in oracle?

581


i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

1801


Is oracle the best database?

518


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1801


How data locks are respected in oracle?

568


How to call a stored function in oracle?

572


Explain the use of parfile option in exp command.

519


How to get maxsal , minsal, ename department wise in single query

1011