How to Remove the 3rd highest salary person record from
table?
Answer Posted / jainish
select max(salary)from employees
where
salary < (select max(salary)from employees where
salary < (select max(salary) from employees))
Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
What happens to the current transaction if the session is killed?
Which is better Oracle or MS SQL? Why?
What are the different types of failures that occur in Oracle database?
What is dynamic proxy?
Can we store pictures in the database and if so, how it can be done?
How to create a new oracle data file?
What is key preserved table?
What is using clause and give example?
How to define an external table with a text file?
What is program global area (pga) in oracle?
How to connect asp pages to oracle servers?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
What is an external table?
What happens to the current transaction if a ddl statement is executed?
What is java oracle used for?