Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...
Answer Posted / mahaboob
I would say that Raj has given the correct answer in general.
In most cases the interviewer restricts the parameter to be
written in the query as it might effect the performance.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to list all indexes in your schema?
How much memory your 10g xe server is using?
Explain how you would restore a database using RMAN to Point in Time?
Difference between oracle's plus (+) notation and ansi join notation?
What happens if variable names collide with table/column names?
What is a snapshot in oracle database?
Explain cascading triggers.
How to commit the current transaction in oracle?
how can we store any pdf file in oracle
what is the difference between functional dependecy and multilevel dependency?
What the is the diff between local index and global index. give some example.
How data locks are respected in oracle?
Explain about functional dependency and its relation with table design?
Who developed oracle & when?
How to create id with auto_increment on oracle?