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
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
How do I uninstall oracle 11g?
How does the on-delete-cascade statement work?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What is a read write transaction in oracle?
How to count duplicated values in a column in oracle?
What is a select query statement in oracle?
How much memory your 10g xe server is using?
Give the various exception types.
ABOUT IDENTITY?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
Explain the difference between sql and oracle?
What to do if dba lost the system password?
What is an oracle cursor variable?
What is a database schema in oracle?