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

What is the difference between sdf and mdf?

1296

How many database files are there in sql server 2000?what are they?

1048

What is the web service used for reporting services?

123

what is denormalization and when would you go for it? : Sql server database administration

1168

Can you tell me about the concept of ER diagrams?

1059

What can be used instead of trigger?

1150

is there a column to which a default can't be bound? : Sql server database administration

1005

Does hive support indexing?

959

Explain what is cte (common table expression)?

1119

How to fine-tune reports?

266

Explain the difference between functions and stored procedures in sql server?

974

Explain query editor regions

1037

What are the new data types are introduced in sql 2000?

895

What does it mean if @@cursor_row returns a negative number?

982

What are the encryption mechanisms in sql server?

1021