find out the second highest salary?
Answer Posted / shiv prakash
select salary from(select rownum as r,salary from(select
rownum,salary from emp order by salary
desc))where r=2;
Is This Answer Correct ? | 20 Yes | 18 No |
Post New Answer View All Answers
How to load data through external tables?
How to view the tablespaces in the current database?
How to sort the query output in oracle?
What is a user account in oracle?
What to do if the binary spfile is wrong for the default instance?
What to do if dba lost the system password?
How to export your own schema?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What happens if you set the sga too low in oracle?
What is oracle update statement with inner join ?
Explain integrity constraint?
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 key preserved table?
What is a proxy object?
Explain oracle instance.