select top 100 max(field name) from Table Name

How to get max 100 values from sql server

Question Posted / vikas

Answer Posted / vikas

Is This Answer Correct ?

12 Yes

17 No

Please Help Members By Posting Answers For Below Questions

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1049

What is the benefit of normalization?

1058

What is ms sql server index?

1071

How to convert a unicode strings to non-unicode strings?

1076

Which tcl commands are available on the sql server?

1057

What is default port number for sql server 2000?

1023

What is the recommended total size of your memory optimized tables?

953

How many databases can we create in a single server?

207

Can two different columns be merged into single column? Show practically?

1041

How to convert a table data in XML format in sql server?

2523

Describe how to use the linked server?

1121

Explain the dirty pages?

981

List out the difference between union and union all in sql server?

969

What is a trigger and types of a trigger?

965

How are the unique and primary key constraints different?

1045