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
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
How do I recompile a procedure in oracle?
Why does oracle 9i treat an empty string as null?
How to create a table index?
Where do we use decode and case statements?
How to select all columns of all rows from a table in oracle?
Is insert autocommit in oracle?
Respected sir, Please send me technical questions related to oracle apps..
How to delete a column in an existing table?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
What is a trigger and what are its types in oracle?
How to use regular expression in pattern match conditions in oracle?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What is enter substitution variable in oracle?
How to connect the oracle server as sysdba?