find out the second highest salary?

Answer Posted / chaitanya pathak

select max(salary) from employee
whrere salary<(selsect max(salary) from employee)

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to define an oracle cursor variable?

567


What is hot backup and logical backup?

608


Differentiate between post-database commit and post-form commit?

543


Why does oracle 9i treat an empty string as null?

539


For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1557






What are the attributes that are found in a cursor?

650


What is the quickest way to fetch the data from a table?

568


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)

1807


How would you change old and new values in an insert, delete and update triggers?

542


What is the minimum client footprint required to connect c# to an oracle database?

565


Can group functions be used in the order by clause in oracle?

580


Why do we use coalesce function in oracle?

629


How to drop a stored procedure in oracle?

592


How do I recompile a procedure in oracle?

527


What are oracle functions?

553