select top 100 (field name)from table name order by (field name) desc

How to get max 100 values from sql server

Question Posted / rekha

7 Answers
13334 Views
I also Faced
E-Mail Answers

Answer Posted / rekha

select top 100 (field name)from table name order by (field
name) desc

Is This Answer Correct ?

14 Yes

6 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

List the types of recovery model available in sql server?

921

Does sql server 2000 clustering support load balancing?

954

How to create new databases with "create database" statements?

1014

What area unit the various kinds of info compression introduced in sql server 2008?

1071

What are parameterized reports?

200

What is log ldf?

971

How to stop a loop early with break statements in ms sql server?

1007

What is difference between views and stored procedures?

977

How to convert a numeric expression from one data type to another?

1001

What is the difference between for auto and for nested?

997

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1934

Where are stored procedures in sql server?

1057

What are unicode character string data types in ms sql server?

1237

How to enable/disable indexes?

1053

Who is the owner of a schema in ms sql server?

1067