SET ROWCOUNT 100 SELECT * FROM TABLENAME

How to get max 100 values from sql server

Question Posted / veeresh kethari

Answer Posted / veeresh kethari

SET ROWCOUNT 100

SELECT * FROM TABLENAME

Is This Answer Correct ?

2 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

169

After removing a table from database, what other related objects have to be dropped explicitly?

1055

Explain intellisense for query editing

1029

What is the difference between mysql and mysqli?

1206

What is parameterized reports in ssrs ?

149

Define primary key?

1140

How to use clusters?

946

What is the name of reporting services config file and what’s it’s used for?

146

Explain cdc and sql injection?

982

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1203

What is a join in sql? What are the types of joins?

1108

Where actually sql azure database is hosted?

163

What is NOT NULL Constraint in sql server 2012?

1000

What is collation sensitivity? Explain different types.

1010

what is sql server? : Sql server database administration

991