Write query to fetch second maximum salary from employee table.
Answer Posted / santosh kumar
select * from(select rownum r,ename,sal from(select * from emp order by sal desc))where r=2;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you mean by merge in oracle and how can we merge two tables?
How to create a stored procedure in oracle?
What is data type in oracle?
What is the relation of a user account and a schema in oracle?
Explain index?
What are the tools for Oracle ?
Can we connect to ORACLE db using Windows Authentication?
Does oracle partitioning improve performance?
How to delete multiple rows from a table in oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is raw datatype in oracle?
What is data file?
Why does oracle 9i treat an empty string as null?
What happens if recursive calls get out of control?
How to export data to a csv file?