find out the second highest salary?
- 55 Answers
- 75883 Views
- Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
- E-Mail Answers
Answer Posted / premsagar12
select max(sal) from emp where sal<(select max(sal) from emp);
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
List out the types of joins.
Is primary key indexed by default in oracle?
What is index in Oracle?
How to create a table index in oracle?
What is the difference between PFILE and SPFILE in Oracle?
What is the implicit cursor in oracle?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
In what script is snap$ created? In what script is the scott/tiger schema created?
Difference between open_form and call_form in oracle.
How to create tables for odbc connection testing?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Whether any commands are used for months calculation? If so, what are they?
How do I connect to oracle database?
Explain the use of log option in exp command.
