How to Select second Maximum salary in a Table ?
Answers were Sorted based on User's Feedback
Answer / 9896012055
select * salary from table < select max(salary) from table
order by salary;
| Is This Answer Correct ? | 0 Yes | 4 No |
Answer / havyas
select sal from table where rownum = 2 order by sal desc
| Is This Answer Correct ? | 1 Yes | 13 No |
How to execute a stored program unit?
How does one get the view definition of fixed views/tables?
How to invoke the data pump export utility?
What is the dynamic sql in oracle?
How to rollback the current transaction in oracle?
what are the advantages of running a database in archive log mode?
How do we represent comments in oracle?
What is an oracle wallet?
What is the Tune Query
State any two functions of oracle?
How to rename a tablespace in oracle?
What is difference between SUBSTR and INSTR?