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

Does mysql support pl sql?

1228


how to select first 5 records from a table? : Sql dba

1022


What is bind variable in pl sql?

1103


what is sql server agent? : Sql dba

1156


Can we join two tables without common column?

1057


What is difference between cursor and trigger?

1129


Why is sql important?

1169


What is the function that is used to transfer a pl/sql table log to a database table?

1066


How many scalar data types are supported in pl/sql?

1102


What are the various restrictions imposed on view in terms of dml?

1016


how can we know the count/number of elements of an array? : Sql dba

1105


What is file based approach?

997


Explain raise_application_error.

1143


Is json a nosql?

1032


What are inner and outer joins examples of both?

1009