Interested to Buy Any Domain ? << Click Here >> for more details...
How to Remove the 3rd highest salary person record from
table?
- 9 Answers
- 19103 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 is difference between sid and service name in oracle?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How to drop an existing view in oracle?
How to change user password in oracle?
How many types of database triggers exist?
Explain the difference between a procedure and a function? What do you understand by those terms?
How to connect the oracle server as sysdba?
Is a rollback possible to any savepoint?
Explain a data segment?
What is a nested table?
Is oracle a programming language?
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 find out what oracle odbc drivers are installed?
What is system global area (sga) in oracle?
How many types of tables supported by oracle?
