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 the advantages of log shipping?

570

How many null values we can have in a unique key field in sql server?

560

Do you know clustered and non-clustered index?

535

What is indexing and its types?

542

Explain index in sql server?

606

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

590

what is the main function of a query parameter?

113

Can you insert NULL in unique column?

642

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

546

How you can get the list of largest tables in a database?

535

What command is used to create a database in the sql server and how?

611

What happens on checkpoint?

624

How would you go about developing a ssrs report?

112

Can You Use Data Mining Models In Ssrs?

Why use update_statistics command in sql server?

568