Interested to Buy Any Domain ? << Click Here >> for more details...
How to Remove the 3rd highest salary person record from
table?
- 9 Answers
- 19119 Views
- HCL, IBM, I also Faced
- E-Mail Answers
Answer Posted / suresh babu
delete from employees where employee_id in (select
employee_id from employees where 3 =(select count(distinct
e.salary) from employees e
where e.salary >= employees.salary));
| Is This Answer Correct ? | 17 Yes | 1 No |
Post New Answer View All Answers
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 privilege is needed for a user to create views in oracle?
What is a snapshot in oracle database?
How to define an anonymous block?
What is the minimum client footprint required to connect c# to an oracle database?
How to delete an existing row from a table in oracle?
What is oracle host variable?
What are the differences between lov and list item?
Can you drop an index associated with a unique or primary key constraint?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
How to assign a tablespace to a users in oracle?
What are the ansi data types supported in oracle?
Can select statements be used on views in oracle?
Explain database link?
What are the most common interview questions on ETL Testing for experience?
