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 / raja

select top1 salary from(select distinct top2 salary from
table name order by salary desc)a order by salary

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a rollup clause?

908


What is the purpose of self join?

914


What is field with example?

868


When would you use the stored procedures or functions?

947


is it important for a database administrator to understand the operating system and file access? : Sql server administration

976


When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

893


Define self join in sql server joins?

899


How to provide values to user defined function parameters?

967


Can you please explain the difference between primary keys and foreign keys?

1057


Which sql server table is used to hold the stored procedure scripts?

1024


Explain filtered indexes benefits?

950


What is resultset concur_updatable?

969


What is the simplest way to create a new database in ms sql server?

954


What is the new security features added in sql server 2014? : sql server security

943


Where can you add custom error messages to sql server?

1053