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

What happens if you lost a data file?

1037


I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2185


Explain oracle’s system global area (sga).

1145


Explain the use of log option in exp command.

1124


Explain overloading. Can functions be overloaded?

1003


How can we find out the duplicate values in an oracle table?

1050


What is analyze command used for?

1080


What is key preserved table?

1026


query optmization techniques and quwry analyser+projects+ppts

2425


what is port in oracle? how is it related to database application.

1950


List out the types of joins.

1164


What is a cursor variable?

1137


What are temporal data types in oracle?

1128


21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2112


How to count duplicated values in a column in oracle?

1050