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 sequence?
How many types of auditing in Oracle?
What is sharded cluster?
How to write an inner join with the where clause in oracle?
How can we create the complete backup of data in the oracle.
What are the attributes of the cursor?
How to lock and unlock a user account in oracle?
what are the advantages of running a database in archive log mode?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What are ddl statements in oracle?
How does Oracle guarantee data integrity of data changes?
How can I see all tables in oracle?
How to install oracle database 10g xe?
What are a collation and state the different types of collation sensitivity?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.