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

write the query for find the top 2 highest salary in sql
server

Answer Posted / ravi pahuja

selecl distinct top 2 salories from emp order by salory 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 stored procedures?

1051


How can we check the sql server version?

1076


When should you use an instead of trigger?

960


What are statistics?

1008


What is transaction server explicit transaction?

1040


How to modify existing triggers using "alter trigger"?

1023


Explain having clause and where clause?

1062


What is the use of custom fields in report?

1000


How to drop an existing table with "drop table" statements in ms sql server?

1090


Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1043


How do you improve the performance of a SQL Azure Database?

137


what is normalization? Explain different levels of normalization? : Sql server database administration

1335


Explain the difference between function and stored procedure?

950


Tell me what are the advantages of using stored procedures?

1018


Explain transaction isolation levels in sql server?

1126