How to Remove the 3rd highest salary person record from
table?
Answer Posted / avnish srivastava-test engg fc
select max(salary)from employees
where
salary < (select max(salary)from employees where
salary < (select max(salary) from employees))
| Is This Answer Correct ? | 10 Yes | 11 No |
Post New Answer View All Answers
What is a table index?
How to use attributes of the implicit cursor in oracle?
What are the attributes of cursor?
How to select an oracle system id (sid)?
How to convert characters to numbers in oracle?
Does oracle database need java?
How to initialize variables with default values?
Explain database link?
What is an oracle data file?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
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 invoke the original export import utilities?
Explain what are the uses of rollback segment?
Can a parameter be passed to a cursor?
How to handle a single quote in oracle sql?