Interested to Buy Any Domain ? << Click Here >> for more details...
How to Remove the 3rd highest salary person record from
table?
- 9 Answers
- 19109 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 end the current transaction in oracle?
How to filter out duplications in the returning rows using oracle?
Explain what are the advantages of views?
How to rename an existing table?
Why cursor variables are easier to use than cursors?
What are the differences between char and nchar in oracle?
Explain the use of grant option in exp command.
What is a system tablespace?
Explain an exception?
How do I uninstall oracle client from windows?
What the is the diff between local index and global index. give some example.
How to handle a single quote in oracle sql?
What is the order of defining local variables and sub procedures/functions?
How will you write a query to get a 5th rank student from a table student_report?
What is the usage of analyze command in oracle?
