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 Update from select query in sql server?

993

What are acid properties of transaction?

894

explain different types of backups avaialabe in sql server? : Sql server database administration

919

Describe and explain about SQL native client?

1038

What is the new security features added in sql server 2014? : sql server security

943

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

977

When is the use of update_statistics command?

950

Explain the properties of a relational table?

976

Can sql servers link to other servers?

1021

Explain Geometry datatype in sql server 2008 with example

919

Which are the olap features?

907

Explain how many types of relationship?

973

Are connections to sql server encrypted?

940

How to add code to the existing article (using improve article)?

1047

Explain how dts is used to extract, transform and consolidate data?

938