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 a nested table?
How to pass a cursor variable to a procedure?
What are group functions in oracle?
What is the difference between sharding and partitioning?
How to define an anonymous block?
Why is oracle database so popular?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
How to install oracle odbc drivers?
How to delete all rows a table in oracle?
What is the usage of control file in oracle?
Can you assign multiple query result rows to a variable?
Explain mutating triggers.
Explain what are the characteristics of data files?
How to put more than 1000 values into an oracle in clause?
Is it possible to insert comments into sql statements return in the data model editor ?