Interested to Buy Any Domain ? << Click Here >> for more details...
How to Remove the 3rd highest salary person record from
table?
- 9 Answers
- 19061 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
what is the difference between functional dependecy and multilevel dependency?
What are a collation and state the different types of collation sensitivity?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
Explain a private synonyms?
How to call a stored function in oracle?
What is the string concatenation operator in oracle?
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?
Explain constraining triggers.
How would you begin to troubleshoot an ORA-3113 error?
How to check your oracle database 10g xe installation?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How to get maxsal , minsal, ename department wise in single query
Explain index?
Explain coalesce function?
Explain what are the type of synonyms?
