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

please tell me the query to get details of the employee
having the second largest salary

Answer Posted / ajay sara

Select Min(Salary) From (Select Top N * From Table_Name
Order by Salary Desc)

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 meant by indexing?

942


How to get a list of columns in a view using the "sp_columns" stored procedure?

988


what is the sql equivaent of the dataset relation object ?

1964


What is t-sql script to take database offline – take database online.

1025


Explain what are the different index configurations a table can have?

1039


What is data set in report?

121


How to automatically create a log when an exception is being received into SQL Server?

1213


What is a file group?

1020


What is change data capture (cdc) feature?

1000


When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1054


What is federation member?

114


What is trigger in salesforce?

904


How to resolve the orphan use problem? : sql server security

956


Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1070


How will you add a dimension to cube? : sql server analysis services, ssas

1013