Interested to Buy Any Domain ? << Click Here >> for more details...
How to Remove the 3rd highest salary person record from
table?
- 9 Answers
- 18730 Views
- HCL, IBM, I also Faced
- E-Mail Answers
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
How can you merge two tables in oracle?
Why cursor variables are easier to use than cursors?
Explain what are the different type of segments?
Give the different types of rollback segments.
How to delete an existing row from a table in oracle?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What are the common oracle dba tasks?
How to convert characters to numbers in oracle?
What are the different windows events activated at runtime ?
What happens to the data files if a tablespace is dropped?
How to start a specific oracle instance?
Please explain oracle data types with examples?
How to retrieve values from data fields in record variables?
What is tns service name?
How to start your 10g xe server from command line?
