How to Remove the 3rd highest salary person record from
table?
- 9 Answers
- 16339 Views
- HCL, IBM, I also Faced
- E-Mail Answers
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
What are temporal data types in oracle?
What is raw datatype in oracle?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
Is java required for oracle client?
What is Java Pool in Oracle?
What is the difference between truncate & delete command?
What is a snapshot in oracle database?
How to define a data source name (dsn) in odbc manager?
What happens if the update subquery returns multiple rows?
Is there a function to split a string in plsql?
What is the parameter mode that can be passed to a procedure?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
How to use windows user to connect to the server?
Explain the use of indexes option in exp command.
