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
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)
How do I manually uninstall oracle client?
How to invoke the data pump import utility?
Which is better Oracle or MS SQL? Why?
How to assign a table row to a record variable?
How to convert csv to table in oracle?
Can we insert data in view oracle?
Which environment variables are absolutely critical in order to run the OUI?
How to update a table row with a record?
What is a nvl function?
What is where clause in oracle?
What happens if you set the sga too low in oracle?
How to use "if" statements on multiple conditions?
What is execute immediate in oracle?
How to export your own schema?