Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / varun
select sal from emp where rownum=2 order by sal desc;
| Is This Answer Correct ? | 6 Yes | 19 No |
Post New Answer View All Answers
What is pl/sql table? Why is it used?
What is sql trigger example?
What is a sql driver?
Why do we use cursors?
What are the different types of a subquery?
What is the primary use of normalization?
How can a function retun more than one value in oracle with proper example?
What is the difference between clustered and non-clustered indexes?
What is the use of double ampersand (&&) in sql queries? Give an example
How to install oracle sql developer?
What is the current version of postgresql?
What is data definition language?
What is an exception in pl/sql?
What are the events on which a database trigger can be based?
Does pdo prevent sql injection?