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

write a query to Find the Maximun second value in table?

Answer Posted / smriti

select salary from(select rownum r,salary from details
order by salary desc)where rownum<2 and salary<(select max
(Salary) from details)

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?

2516


Define view, sequence and index in DBMS.

877


Write about Transaction Management in Oracle 9i?

2062


How can you get the alternate records from the table in the sql?

902


What is the best database software?

844


What are the examples of database?

845


What is artificial key?

835


What is the purpose of database management system?

993


Define entity set.

856


How to determine who is and change the owner of database?

890


What is difference between database and schema?

931


What is database optimization?

887


What is a candidate key in dbms?

996


What is tuple in rdbms?

1019


What is database Configuration assistant ?

1093