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 / pramod majhi

select max(salary) from employees where salary<(select
max(salary) from employees);

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the advantages of using stored procedures? : Sql dba

1102


what is bdb (berkeleydb)? : Sql dba

1029


What are inbuilt functions in sql?

1050


What are all the different types of indexes?

1147


Is sql low level language?

1014


Does truncate remove indexes?

1024


Can we rollback delete command?

980


what is a constraint? Tell me about its various levels. : Sql dba

983


Can you selectively load only those records that you need? : aql loader

1044


Why do we use partitions in sql?

1041


What are the two characteristics of a primary key?

969


What problem one might face while writing log information to a data-base table in pl/sql?

1155


Is sql sequential or random?

1027


What is difference between pl and sql?

1054


What is the difference between python and sql?

995