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 transaction isolation levels in sql server?

1088

Explain about extended stored procedure?

912

Difference between group by clause and having clause in SQL?

955

What is your recommendation for a query running very slow? : sql server database administration

1025

What is role playing dimension with two examples? : sql server analysis services, ssas

980

Which tcl commands are available on the sql server?

1059

What are the steps to process a single select statement?

921

what are the new features in SSRS?

134

What is the difference between ddl,dml and dcl commands?

1092

Explain go command in sql server?

1008

How to replace null values in expressions using isnull()?

1079

How many columns can exist together per table?

1139

Can we use where clause with group by?

880

What do you understand by mirroring and mention the advantages of the mirroring?

1045

What are the elements of dbms?

946