Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to Remove the 3rd highest salary person record from
table?

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


Please Help Members By Posting Answers For Below Questions

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

952


What are a collation and state the different types of collation sensitivity?

1095


What is oracle in java?

913


Explain the use of grant option in exp command.

1006


What is catalog in Oracle?

1265


What are the limitations oracle database 10g xe?

979


 What are the oracle DML commands possible through an update strategy?

1006


How many memory layers are in the oracle shared pool?

1107


How to execute a stored procedure in oracle?

1031


Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2176


Is there an oracle sql query that aggregates multiple rows into one row?

934


What is a user role in oracle?

1067


What is logical backup in oracle?

969


What are the different types of failures that occur in Oracle database?

1016


Can we create database in oracle using command line ?

1031