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 / sudhakara reddy k

select 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 concurrency in oracle?

946


How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2205


What are the limitations of check constraint?

962


How is it different from a normal table?

966


Explain the use of grant option in imp command.

958


what is Single Byte Overhead...?

2498


What are the execution control statements?

1015


List the types of joins used in writing subqueries?

941


What are the differences between lov and list item?

990


What are transaction isolation levels supported by oracle?

994


What is a dead lock in oracle?

1048


What is a cursor in oracle?

1106


How to define a variable to match a table column data type?

937


In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2211


Who developed oracle & when?

944