Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...
Answer Posted / samad
Dear
here i am sending new ans u can give the value in parameter
SELECT SAL,NO FROM(
SELECT SAL ,ROWNUM NO FROM
(SELECT DISTINCT SAL FROM EMP ORDER BY SAL DESC)) WHERE NO=:N
Regards,
Samad
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is oracle data type?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How to create a table index?
What privilege is needed for a user to delete rows from tables in another schema?
Explain the use of Merge statement in oracle 11g
Is postgres faster than oracle?
Describe the types of sub query?
How to retrieve the count of updated rows?
What are the most common interview questions on ETL Testing for experience?
How to load excel data sheet to oracle database
is there a tool to trace queries, like profiler for sql server?
What is the fastest query method to fetch data from the table?
How to unlock the sample user account in oracle?
What is an oracle and why it is used?
What is oracle latest version?