find out the third highest salary?

Answer Posted / paridhi

select top 1 salary from
(select top 1 salary from employee order by
salary desc) a
order by salary

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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 do I manually uninstall oracle client?

520


How to invoke the data pump import utility?

653


Which is better Oracle or MS SQL? Why?

3987


How to assign a table row to a record variable?

584






How to convert csv to table in oracle?

528


Can we insert data in view oracle?

543


Which environment variables are absolutely critical in order to run the OUI?

1662


How to update a table row with a record?

597


What is a nvl function?

566


What is where clause in oracle?

534


What happens if you set the sga too low in oracle?

559


How to use "if" statements on multiple conditions?

723


What is execute immediate in oracle?

549


How to export your own schema?

577