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 / prem chhappesh

select max(salary) from emoplyee where salary not in(select max(salary) from employee)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the primary key?

958


What is a behavioral trigger?

983


What is delimiter sql?

1014


what are the security recommendations while using mysql? : Sql dba

1129


How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2229


Why do we use subquery?

1022


What is the difference between alter trigger and drop trigger statements?

1118


Explain mutating table error.

1214


What is offset in sql query?

1127


What is row_number () in sql?

991


how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1199


What is substitution variable in pl sql?

1052


List and explain the different types of join clauses supported in ansi-standard sql?

1359


Does sap use sql?

999


What is the best sql course?

990