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 scan table/view and seek table/view when its occurs? : sql server database administration

1023

Why I am getting this error when dropping a database in ms sql server?

1058

Explain a checkpoint?

1011

What is meant by referential integrity?

995

What is the difference between createstatement and preparedstatement?

920

How to convert numeric values to integers in ms sql server?

1060

How to insert new line characters into strings?

968

Is it possible for a stored procedure to call itself or recursive stored procedure?

931

How to list all login names on the ms sql server?

1121

Explain the functionalities that views support?

1098

What is an indexed view?

945

What is trace flag in sql server?

1004

How to find the login name linked to a given user name?

991

What is model database? : SQL Server Architecture

1109

What do you understand by recursive stored procedures?

970