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 the second highest salary of the emp table

Answer Posted / guest

ANS:
select max(salary) from Employees
where salary not in
(select max(salary) from Employees )

Is This Answer Correct ?    9 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are the uses of rollback segment?

1013


What is a table index?

1098


What are temporal data types in oracle?

1121


In which language oracle has been developed?

1073


What is dynamic proxy?

1005


What is a cognitive schema?

963


Is insert autocommit in oracle?

1068


How to assign values to variables?

1101


What is execute immediate in oracle?

1021


How to define an anonymous procedure without variables?

1106


How to Truncate Table in Oracle

1154


Explain the use of Merge statement in oracle 11g

1027


How to turn on or off recycle bin for the instance?

1083


What does sharding mean?

1000


Can we write insert statement in function in oracle?

1089