find out the second highest salary?
Answer Posted / mallikarjun
select max(sal) from emp
where sal < select max (sal)from emp
Mallikarjun
| Is This Answer Correct ? | 216 Yes | 86 No |
Post New Answer View All Answers
What are the major difference between truncate and delete?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
How to create a new table by selecting rows from another table?
State some uses of redo log files?
Explain the use of compress option in exp command.
How to add a new column to an existing table in oracle?
How to connect to oracle using service name instead of sid?
What happens if you set the sga too low in oracle?
What is control file used for?
Hi Can any one tell me what are the API's used in requisition import.
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How many categories of data types in oracle?
State any two functions of oracle?
What are the differences between date and timestamp in oracle?