How to Remove the 3rd highest salary person record from
table?
Answer Posted / basanti
delete from employee where salary(select salary from(select
distinct (salary) from employee where salary is NOT NULL
order by salary desc) where rownum=n);
Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What are the ansi data types supported in oracle?
Explain the use of ignore option in imp command.
What is a read only transaction in oracle?
What is the string concatenation operator in oracle?
How to update a table row with a record?
What is SQL access advisor in Oracle?
Please explain compound trigger in oracle?
What is a snapshot in oracle database?
what is normalisation?what are its uses?
What is the difference between post-database commit and post-form commit?
How to drop a tablespace?
What is coalesce function?
What is the difference between a user and a schema in oracle?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How to check the server version in oracle?