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
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
How do you tell what your machine name is and what is its IP address?
How to omit columns with default values in insert statement in oracle?
What is index in Oracle?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How to create a new table in oracle?
Where is the export dump file located?
Can a formula column be obtained through a select statement ?
How to get execution path reports on query statements?
How to invoke the data pump import utility?
How to create a table interactively?
What do you mean by redo log file mirroring?
Why packages are used in oracle?
How much memory your 10g xe server is using?
How to define an anonymous block?