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

explain different levels of normalization? : Sql server database administration

929

What are the options which must be set to allow the usage of optimistic models?

915

What are the advantages of the mirroring?

1013

What are the different Topologies in which Replication can be configured?

1118

How to find Duplicate Records In table?

959

How to provide column names in insert statements in ms sql server?

1073

Differentiate between mongodb vs. Sql server?

1032

Why are you getting errors when creating a new odbc dsn?

1166

What does sql server mean?

974

What is the use of “join” in sql server?

1017

What is temporary table in sql server? Why we use temp table?

906

How to get the definition of a user defined function back?

1000

Explain what role entity and relationship play in an ER diagram.

1016

What is bulkcopy in sql?

899

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1548