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 resource governor in sql server?

1007

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

121

What are the filtered indexes?

1040

How adventureworkslt tables are related?

934

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8158

Explain optimistic and pessimistic concurrency?

996

How does a profiler work?

936

Can you explain what is sql server english query?

1000

Is foreign key a primary key?

1102

How to create new tables with "select ... Into" statements in ms sql server?

991

What is a transact-sql statement batch in ms sql server?

1027

How to read data in a table with "select" statements?

975

Can you pass expressions to function parameters?

1107

How you can add messages to the nt event log from within a stored procedure?

1071

Explain candidate key, alternate key, and composite key?

1003