How to Remove the 3rd highest salary person record from
table?
Answer Posted / nathan
DELETE FROM emp
WHERE empno = (SELECT empno
FROM (SELECT empno, ROWNUM rn
FROM (SELECT empno
FROM emp
ORDER BY sal DESC))
WHERE rn = 3);
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is max rowid in oracle?
What are group functions in oracle?
What to do if dba lost the system password?
How many types of synonyms in Oracle?
How to create a temporary table in oracle?
What are the data types in oracle?
Explain about your project and its relation to the current job position you are applying to?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
Is it possible to split the print reviewer into more than one region ?
how do u setup a replication site?
What are the roles of dba?
How to use existing values in update statements using oracle?
How to insert multiple rows with one insert statement in oracle?
What is a read only transaction in oracle?
What is oracle and what are its different editions?