How to Remove the 3rd highest salary person record from
table?
- 9 Answers
- 16384 Views
- HCL, IBM, I also Faced
- E-Mail Answers
Answer Posted / khan
DELETE FROM
(SELECT EMP_ID, SALARY, DENSE_RANK() OVER (ORDER BY SALARY DESC) AS CNT FROM EMPLOYEE)
WHERE CNT = 3;
| Is This Answer Correct ? | 9 Yes | 5 No |
Post New Answer View All Answers
Is oracle a relational database?
Is oracle an operator?
What are the extensions used by oracle reports?
Explain what are the different type of segments?
What is oracle analytical function?
How to view existing locks on the database?
Explain rename?
Explain about the analyze command in oracle?
Compare and contrast between sql and sql server and explain its various functions?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What is the difference between online and offline backups?
What is instant client oracle?
How to set a transaction to be read only in oracle?
What is the difference between "as" and "is" in an oracle stored procedure?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
