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...

can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com

Answer Posted / arun ashok

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

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is bulkcopy in sql?

943


What is the stored procedure?

1009


What is bookmark link in ssrs?

244


How can you tell if a database object is invalid?

1074


Explain log shipping?

1011


What is the significance of master, tempdb and model databases?

1078


What is normalization of database? What are its benefits?

1026


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2362


What is an execution plan?

1148


How to recreate an existing index in ms sql server?

1055


Define indexes?

1041


What are views used for?

1014


What is database black box testing?

1033


What is the difference between DataRow.Delete() and DataRow.Remove()?

1230


How to create a Master database in SQL server ?

1088