How to Remove the 3rd highest salary person record from
table?
Answer Posted / krishna
delete from emp where sal >(select max(sal) from emp where
sal >(select max(sal) from emp where sal >(select max(sal)
from emp)));
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How to loop through a cursor variable?
master table and child table performances and comparisons in Oracle ?
How to open a cursor variable?
How to pass a cursor variable to a procedure?
Explain the use of online redo log files in oracle.
How to convert numbers to characters in oracle?
How many types of cluster table in Oracle?
What is the meaning of recursive hints in oracle?
How different is ms access and oracle?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Explain the use of control file?
How to convert characters to numbers in oracle?
What is the parameter mode that can be passed to a procedure?
How to list all indexes in your schema?
What are the general rules on data consistency?