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
Can we convert a date to char in oracle and if so, what would be the syntax?
How much memory your 10g xe server is using?
what are actual and formal parameters?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
what is Single Byte Overhead...?
How to calculate date and time differences in oracle?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
Explain the use of rows option in exp command.
Explain what are the advantages of views?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What is varray?
What is a user role in oracle?
What are named parameters?
How to get the Installed Oracle Version Information ?
What are a cluster and non-cluster index?