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 find out second largest value in the table

Answer Posted / mk

select *from emp where sal=(select distinct(max(sal)) from
emp where sal <select max(sal) from emp )

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is Java Pool in Oracle?

1248


How to login to the server without an instance?

1217


Name the three major set of files on disk that compose a database in Oracle?

1170


how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2119


What is Undo Management Advisor in Oracle?

1154


What are the ways tablespaces can be managed and how do they differ?

2450


What are the different types of database objects?

1120


What are the uses of Database Trigger ?

1788


What is an external table?

1084


List out the difference between commit, rollback, and savepoint?

1094


What is meant by joins?

1109


What is archive log in Oracle?

1184


What is the difference between truncate & delete command?

1236


How to change program global area (pga) in oracle?

1148


Explain integrity constraints?

1159