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

select * from (
select * from test where sal < (select max(sal) from test)
order by 2 desc)
where rownum =1

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to pass parameters to procedures in oracle?

997


if you ctreate table identity

2316


What is private procedure oracle?

958


Where is the export dump file located?

1082


Write a trigger example in oracle?

983


22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

1957


What is meant by raw datatype?

1005


How to use attributes of the implicit cursor in oracle?

951


Explain parameter file in oracle.

974


What are the common oracle dba tasks?

1072


What are the uses of Database Trigger ?

1625


Explain what are the uses of rollback segment?

961


What is the difference between a hot backup and a cold backup in oracle?

961


What is connection pool in oracle?

930


What is a tns file?

941