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 language does oracle use?
How to drop an index?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
What is the simplest tool to run commands on oracle servers?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
what is difference between sql plus and sql*plus? (not sql and sql plus).
What is an oracle database?
What are the types of trigger in oracle?
How to check your oracle database 10g xe installation?
How to lock and unlock a user account in oracle?
What are the different types of database objects?
What is a database schema in oracle?
Can group functions be mixed with non-group selection fields?
How to add a new column to an existing table in oracle?
Where are the settings stored for each instance in oracle?