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 / krishna

delete from emp where sal >(select max(sal) from emp where
sal >(select max(sal) from emp where sal >(select max(sal)
from emp)));

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to loop through a cursor variable?

1126


master table and child table performances and comparisons in Oracle ?

2195


How to open a cursor variable?

1088


How to pass a cursor variable to a procedure?

1156


Explain the use of online redo log files in oracle.

1077


How to convert numbers to characters in oracle?

1077


How many types of cluster table in Oracle?

1080


What is the meaning of recursive hints in oracle?

1098


How different is ms access and oracle?

1089


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2310


Explain the use of control file?

1173


How to convert characters to numbers in oracle?

1112


What is the parameter mode that can be passed to a procedure?

1108


How to list all indexes in your schema?

1140


What are the general rules on data consistency?

1061