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

how to find the second salary?

Answer Posted / sandeep rana

select max(salary) from salary_table where salary in(select
top 2 salary from salary_table order by salary desc)

Is This Answer Correct ?    2 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can I get data from a database on another server?

1051


explain how to create a new schema in a database? : Sql server database administration

1159


What is openxml in sql server?

1224


You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1193


How to make conditional sum in ssrs?

183


What is clustered primary key?

1084


How to find index size for each index on table?

1057


Explain a checkpoint?

1089


Why de-normalization required?

1055


What are different types of data sources?

1085


What is the stuff and how does it differ from the replace function?

1227


Why use sub query in sql server and list out types of sub queries?

1060


What is dbcc updateusage?

1258


Explain the functionalities that views support?

1162


How to delete duplicate rows in sql server?

1156