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...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

How to Select second Maximum salary in a Table ?

Question Posted / havyas

Answer Posted / havyas

select sal from table where rownum = 2 order by sal desc

Is This Answer Correct ?    1 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to shutdown your 10g xe server from command line?

1038

Why use resource manager in Oracle?

1071

How to store only time; not date and time?

982

What is a sub query? What are its various types?

1110

How to convert characters to dates in oracle?

1053

What are ddl statements in oracle?

1031

What is oracle thin client?

990

Is primary key indexed by default in oracle?

949

What is the difference between formal parameters and actual parameters?

1036

Explain about functional dependency and its relation with table design?

974

What happens to indexes if you drop a table?

1134

How to store pictures on to the database?

936

State and explain about oracle instance?

955

What do you understand by a database object? Can you list a few of them?

991

What is where clause in oracle?

1000