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 is difference between sid and service name in oracle?
What is the database name in oracle?
Can we store pictures in the database and if so, how it can be done?
How to assign query results to variables?
What is a nvl function?
What is the difference between view and materialized view in Oracle?
What is merge statement used for?
1) Does oracle have any table which contain all the exceptions and it's code internally?
What would you do with an in-doubt distributed transaction?
What is the parameter mode that can be passed to a procedure?
Explain the use of rows option in imp command.
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
What is bulk collect in oracle?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is the difference between primary key and unique key and foreign key in oracle?