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

What are ddl triggers and types of ddl trigger?

1040

What is the main purpose of having conversation group?

900

what are different types of backups available in sql server? : Sql server database administration

938

what changed between the previous version of sql server and the current version? : Sql server database administration

1014

Why we use functions in sql server?

1080

how many bits ip address consist of? : Sql server database administration

900

How much does sql server 2016 cost?

1074

How can you find out how many rows returned in a cursor?

1030

How do you use a subquery to find records that exist in one table and do not exist in another?

1050

What is compression - row-level and page-level compression?

918

how to create “alternate row colour”?

146

What is the difference between stored procedure and functions?

1135

What is isnull() operator?

1040

How can you insert null values in a column while inserting the data?

1282

Can we use custom code in ssrs?

1116