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
What is query image?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Is there any function in oracle similar like group_concat of mysql?
How to create a temporary table in oracle?
Explain the use of rows option in exp command.
What is the usage of merge statement?
When system tablespace is created?
What are transaction isolation levels supported by oracle?
What is a static data dictionary in oracle?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
How to use fetch statement in a loop?
How is it different from a normal table?
What is an oracle and why it is used?
What is SQL access advisor in Oracle?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?