Write query to fetch second maximum salary from employee table.
Answer Posted / vijayalakshmi
select top 1 Coumn_Name from (select top 2 Coumn_Name from Table_name order by Coumn_Name desc) b order by Coumn_Name
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain the use of analyse option in exp command.
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 to handle a single quote in oracle sql?
Can we insert data in view oracle?
How to execute a stored program unit?
What are the differences between blob and clob in oracle?
What is raw datatype?
Difference between hot backup vs. Cold backup?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What privilege is needed for a user to create indexes in oracle?
How to use "in" parameter properly?
How to see the table columns used in an index?
What is the database name in oracle?
Explain the use of inctype option in exp command.
Difference between the “verify” and “feedback” command?