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 get 2nd maximum salary in an employee table ?

Answer Posted / deepa

select min(salary) from (select salary from table_name order by salary desc) where rownum<3;

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is blind sql injection?

1063


How to add new employee details in an employee_details table with the following details

1085


What is loop in pl sql?

1033


What is denormalization in a database?

1044


What is composite primary key in sql?

992


How to create an array in pl/sql?

1062


What is nosql example?

1026


Does inner join return duplicate rows?

971


How do I add a database to sql?

1121


Determine if oracle date is on a weekend?

1033


what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1644


Mention what pl/sql package consists of?

990


Explain cursor types?

1018


what are the t string functions available in tsql? : Transact sql

1002


Why is pl sql needed?

926