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...

find out the third highest salary?

Answer Posted / manoj

select salary from emp
where salary = (select max (salary) from emp
where salary < (select max (salary) from emp
where salary < (select max (salary) from emp)));

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

State the difference between a primary key and foreign key?

935


How to create a new tablespace in oracle?

983


how may join possible between (requisition with purchase order)

2246


How to write numeric literals in oracle?

1182


Difference between the “verify” and “feedback” command?

1362


State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1030


How to upsert (update or insert into a table)?

997


What are the general rules on data consistency?

1009


What is Reduced List of Values?

2160


How would you go about verifying the network name that the local_listener is currently using?

2046


How do I spool in oracle?

1004


How to create a testing table in oracle?

988


How to concatenate two text values in oracle?

1112


What are the differences between lov and list item?

1063


Difference between cartesian join and cross join?

1034