find out the third highest salary?
Answer Posted / punit chauhan
select * from emp where sal<(select max(sal) from emp
where sal<(select max(sal) from emp))
punit chauhan
iMS NOIDA
doing MCA
Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
What are the major difference between truncate and delete?
How do I call oracle stored procedures that take no parameters?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is an oracle user account?
Explain constraining triggers.
How would you change old and new values in an insert, delete and update triggers?
What are the differences between char and nchar in oracle?
Is a rollback possible to any savepoint?
Where do we use decode and case statements?
 How to use an oracle sequence generator in a mapping?
How to write text literals in oracle?
What are the arithmetic operations?
Is insert autocommit in oracle?
Explain the use of compress option in exp command.
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??