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

Determine when an index is appropriate?

1073


While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

982


Can you explain what are commit and rollback in sql?

936


How can you stop stored procedures from recompiling?

897


What is the purpose of optimization?

992


What is multilevel indexing?

927


What are user-defined functions (udfs) in sql server?

986


What is the native system stored procedure to execute a command against all databases?

1023


What is the stuff?

994


What causes index fragmentation?

991


Tell me the difference between clustered and non-clustered index?

931


What is a cursor, index in sql?

1069


Can you explain full-text query in sql server?

1009


Difference between DELETE and TRUNCATE?

1047


How can a database be repaired?

986