Interested to Buy Any Domain ? << Click Here >> for more details...
find out the second highest salary?
- 55 Answers
- 91252 Views
- Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
- E-Mail Answers
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 sharding and replication?
What is oracle rownum?
What are the different types of failures that occur in Oracle database?
How do we represent comments in oracle?
When do you get a .pll extension in oracle? Explain its importance
How to shutdown your 10g xe server from command line?
Can we save images in a database and if yes, how?
Which environment variables are absolutely critical in order to run the OUI?
How to convert characters to numbers in oracle?
What is an oracle tablespace?
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 the difference between primary key and unique key and foreign key in oracle?
Explain an exception and its types?
why dont we assign not null constraint as table level constraint.
What is a server parameter file in oracle?
