find out the third highest salary?
Answer Posted / ram pravesh
select max(sal) from emp where sal<(select max(sal)from emp
where sal<(select max(sal) from emp))
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How can Oracle users be audited?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
What is difference between truncate and delete?
what is the scenario where you take the database to NoArchivelog mode?
What is the difference between substr & instr functions?
How to select all columns of all rows from a table in oracle?
How to insert a new row into a table in oracle?
What is PL/SQL ?
How to use regular expression in pattern match conditions in oracle?
Give the various exception types.
What are the different types of record groups in oracle? Explain each of them
State and explain about oracle instance?
Why is oracle used?
How to create a single index for multiple columns?
What is the usage of analyze command in oracle?