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 Select second Maximum salary in a Table ?

Answer Posted / 9896012055

select * salary from table < select max(salary) from table
order by salary;

Is This Answer Correct ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What happens to the indexes if a table is recovered?

993


normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2208


In the oracle version 9.3.0.5.0, what does each number shows?

1303


What are the uses of a database trigger?

994


How to create a single index for multiple columns?

1039


What is control file used for?

1211


Whats the benefit of dbms_stats over analyze?

2005


Can group functions be used in the order by clause in oracle?

999


How to select an oracle system id (sid)?

1064


Explain oracle’s server parameter file.

997


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

1014


Why use resource manager in Oracle?

1109


Can group functions be mixed with non-group selection fields?

1021


Explain mutating triggers.

1034


Does oracle charge for java?

1058