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

select distinct sal from emp a where 2 = (select count
(distinct sal) from emp b where a.sal <= b.sal)

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do database buffers contain?

979


How to use null as conditions in oracle?

1026


1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

2037


What is BBED in Oracle?

1105


What is the max number of columns in an oracle table?

948


What is a static data dictionary in oracle?

1050


Why is oracle so popular?

947


How will you write a query to get a 5th rank student from a table student_report?

1827


How to load data through external tables?

1089


What are the advantages of oracle?

977


What is a named program unit?

1036


Can we write dml statement in function in oracle?

1042


What is a data dictionary and how can it be created?

1081


What is oracle rownum?

902


Give the advantages and disadvantages of clusters.

1008