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 get max 100 values from sql server

Answer Posted / veeresh kethari

set rowcount 100
select * from tablename

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to divide query output into multiple groups with the group by clause in ms sql server?

1011


How can sql server instances be hidden?

926


What do you mean by SQL injection attack?

1038


How do I setup a sql server database?

1053


What have included columns when we talk about sql server indexing?

1015


Explain linked server in sql?

1195


After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

936


What is a collation in ms sql server?

1056


What is store procedure? When do you use?

909


Where do you find the default Index fill factor and how to change it?

1047


What is page in sql server?

930


What is multilevel indexing?

915


What do we have to check in database testing?

994


What is the primary use of the model database?

1065


What is apply operator in sql?

990