Interested to Buy Any Domain ? << Click Here >> for more details...
How to Remove the 3rd highest salary person record from
table?
- 9 Answers
- 19370 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
What is the difference between truncate & delete command?
How to create a table index in oracle?
candidate key is subset of super key but not vice-verse explain
What is a trigger and what are its types?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
How to retrieve values from data fields in record variables?
How to update a table row with a record?
What are privileges and grants?
What are the original export and import utilities?
List the various oracle database objects?
How do I learn what codesets are available in oracle?
How to define a variable to match a table column data type?
Explain the types of exception?
What is system tablespace?
Which is better Oracle or MS SQL? Why?
