find out the third highest salary?
Answer Posted / arijit
donno whether the rest are correct ..but this one is:-
select max(sal) from emp where sal<(select max(sal) from emp
where sal<( select max(sal) from emp));
Is This Answer Correct ? | 52 Yes | 17 No |
Post New Answer View All Answers
What are the original export and import utilities?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What is instant client oracle?
How to build data dictionary view an new database?
What happens if you set the sga too low in oracle?
How to assign a tablespace to a users in oracle?
why dont we assign not null constraint as table level constraint.
What is the relation of a user account and a schema?
What is tns service name?
What is a database schema in oracle?
How to delete a user account in oracle?
How to increment dates by 1 in oracle?
What happens if the imported table already exists?
How to define an oracle sub procedure?
How to load data from external tables to regular tables?