SELECT TOP 100 FIELD_NAME FROM TABLE_NAME ORDER BY FIELD

How to get max 100 values from sql server

Question Posted / zulfikar ali

Answer Posted / zulfikar ali

SELECT TOP 100 FIELD_NAME
FROM TABLE_NAME
ORDER BY FIELD_NAME DESC

Is This Answer Correct ?

9 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to create dbo table in sql server?

1003

What do you mean by acid?

1055

When multiple after triggers are attached to sql table, how to control the order of execution?

1101

Is sql server difficult to learn?

966

What the difference between UNION and UNIONALL?

1086

What are the types of processing and explain each? : sql server analysis services, ssas

1205

Define ACID properties in a Database?

1102

What is left outer join in sql server joins?

1105

Can I save my report as html, excel or word? : sql server management studio

1007

What is the purpose of sql profiler in sql server? : sql server database administration

1156

Explain transaction isolation levels in sql server?

1181

Which tcp/ip port does the sql server run on? How can it be changed?

1105

Tell me the use of keyword with encryption. Create a store procedure with encryption?

1055

What are the different normalization forms?

1162

What is difference between foreign key and unique key?

1047