How to Remove the 3rd highest salary person record from
table?
- 9 Answers
- 16435 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
Why should I use oracle database?
Explain the use of compress option in exp command.
What is recovery manager(rman) backup in Oracle?
Why do we use coalesce function in oracle?
how may join possible between (requisition with purchase order)
How to create tables for odbc connection testing?
What are the built-in functions used for sending Parameters to forms ?
How will you identify oracle database software release?
What is a view and how is it different from a table?
what is difference between sql plus and sql*plus? (not sql and sql plus).
How do I find the database name in oracle?
What do you mean by merge in oracle and how can you merge two tables?
How to list all indexes in your schema?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
