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
What are the execution control statements?
How to connect ms access to oracle servers?
What are the different types of modules in oracle forms?
What is bulk copy or bcp in oracle?
What is Reduced List of Values?
What is set operator oracle?
What is an oracle function?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What is the difference between online and offline backups?
What is an oracle database table?
What happens to indexes if you drop a table?
What are the benefits of ordbms?
What are the differences between lov and list item?
What are the original export and import utilities?
How to shutdown your 10g xe server from command line?