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 largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database

plz mail the answer @ mak2786@gmail.com

Answer Posted / gunjan sapra

select top 10 from tbl_name order by salary desc

Is This Answer Correct ?    4 Yes 39 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are parameterized reports?

195


Can two tables share a primary key?

971


What are the key configuration files for sql server reporting services ?

165


How many categories of functions based their return modes?

1074


What do you mean by cardinality?

870


What information is maintained within the msdb database?

936


What is primary key, unique key, and foreign key?

940


Do I need a report server to run reports in my application?

161


Define cursor locking

969


What is RMS migrations?

2107


How are the unique and primary key constraints different?

1027


What are the types of lock supported by ?

1011


What are the advantages of user defined function?

949


What are the new scripting capabilities of ssms? : sql server management studio

1018


What are truncate options available in sql server? : sql server database administration

989