Interested to Buy Any Domain ? << Click Here >> for more details...
How to Remove the 3rd highest salary person record from
table?
- 9 Answers
- 19146 Views
- HCL, IBM, I also Faced
- E-Mail Answers
Answer Posted / basanti
delete from employee where salary(select salary from(select
distinct (salary) from employee where salary is NOT NULL
order by salary desc) where rownum=n);
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
How to retrieve values from data fields in record variables?
What is oracle instant client?
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.
Explain the use of record option in exp command.
What is tns service name?
What are the different types of modules in oracle forms?
How to create a stored function in oracle?
Is oracle a programming language?
Explain about functional dependency and its relation with table design?
What is an anonymous block?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
Explain the use of grant option in imp command.
what is the difference between functional dependecy and multilevel dependency?
How do we create privileges in oracle?
How to calculate date and time differences in oracle?
