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

What is the difference between Stored Procedures and triggers?

1130


Can we use custom code in ssrs?

1161


What is sub query and its properties?

1021


What is a scheduled job or what is a scheduled task?

1001


Tell me the phases a transaction has to undergo?

1013


Can we insert data into view sql server?

977


How to delete duplicate records based on single column from a table?

1099


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

2121


your distribution database is full what will u do

2217


What type of locking occurs during the snapshot generation? : sql server replication

1371


what type of index will get created after executing the above statement? : Sql server database administration

1023


What is the difference between createstatement and preparedstatement?

997


How do I find my localdb version?

1023


Explain boyce and codd normal form(bcnf)?

1008


Write a code to select distinct records without using the DISTINCT keyword.

1177