find out the second highest salary?
Answer Posted / radhiv kumar
PROC SQL;
SELECT MAX(SALARY) FROM RIGHTMER1
WHERE SALARY < SELECT MAX (SALARY)FROM RIGHTMER1;
QUIT;
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the difference between formal parameters and actual parameters?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How to select all columns of all rows from a table in oracle?
Can you have more than one content canvas view attached with a window ?
What is background process in Oracle?
What privilege is needed for a user to create indexes in oracle?
Explain the use of show option in imp command.
How can we force the database to use the user specified rollback segment?
How to pass parameters to procedures in oracle?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is the maximum limit on the number of columns in a table?
What is the quickest way to fetch the data from a table?
What do you mean by a deadlock?
What is the use of oracle?
What is a relational database management system?