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

Answer Posted / rekha

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

Is This Answer Correct ?

14 Yes

6 No

Please Help Members By Posting Answers For Below Questions

How to locate and take substrings with charindex() and substring() functions?

1070

How can you manage sql azure security?

105

Name the different type of indexes in sql?

1012

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

1030

What the different components in replication and what is their use?

997

How to test a dml trigger in ms sql server?

1105

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1112

What is cursors? And what are the different types of cursor?

1194

What is pessimistic concurrency?

1021

What is dbcc updateusage?

1256

How to deploy the Report?

140

What are different types of collation sensitivity?

1023

Working with TLogs

1895

What do you understand by a stored procedure?

1149

What are the results of running this script?

974