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 alternate keys?

934

How to execute the cursor queries with "open" statements?

1096

What is local temp table?

895

How extra digits are handled with numeric data type literals?

911

Give main differences between "Truncate" and "Delete".

1032

How to filter out duplications in the returning rows in ms sql server?

1066

How can you know if the row fetched from cursor is still valid in underlying table?

953

What is RAID? What are the different types of RAID configurations?

1063

Difference between LEN() and DATALENGTH() in sql server ?

1057

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

882

What is function of ROLLUP ?

1036

How connect excel to sql server?

929

What are the restrictions while creating batches in sql server?

1004

Are resultset updatable?

895

What is report subscription?

117