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 / mallikarjuna

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

What are database links used for?

988


what is a composite key ? : Sql dba

993


Can two tables have same primary key?

915


What is the maximum number of triggers, you can apply on a single table?

944


What are the benefits of stored procedures?

995


Differentiate pl/sql and sql?

1010


What are the qualities of 2nf?

973


How to return an array from java to pl/sql?

1060


How to write a query to show the details of a student from students table whose

936


What are the key differences between SQL and PL SQL?

1146


Can you skip header records while loading? : aql loader

969


What are the features of pl sql?

1012


how is myisam table stored? : Sql dba

995


Is sql between inclusive?

1057


Can cursors be part of a trigger body?

1583