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

Will you be able to store pictures in the database?explain.

1040


How to view all columns in an existing table?

984


How to convert characters to numbers in oracle?

1113


How to create a server parameter file?

1188


Explain a data segment?

1112


What is an oracle table?

1033


Is oracle the best database?

1010


How do you tell what your machine name is and what is its IP address?

2156


What does sharding mean?

1055


How to commit the current transaction in oracle?

1188


What is dual table oracle?

1030


What are the numeric comparison operations?

1167


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.

2246


What is transaction control statement and how many types of transaction control statement in Oracle?

1236


How to get a list of all user accounts in the database?

1131