find out the second highest salary?
Answer Posted / amulya kumar panda
select max(salary) from employee where
salary<(select max(salary) from employee)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to create a new user account in oracle?
Explain the use of show option in imp command.
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
Explain the function of optimizer in oracle?
master table and child table performances and comparisons in Oracle ?
What is difference between cartesian join and cross join?
What is meant by raw datatype?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
How to rename an index?
How to start your 10g xe server from command line?
How to Truncate Table in Oracle
What is the sid in oracle?
material view and view disadvantages?
What do you understand by database schema and what does it hold?