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

Explain how to maintain a fill factor in existing indexes?

974

What is forward - only cursors / read only cursor?

1071

How many types of triggers are there?

1043

Explain what are the basic functions for master, msdb, model, tempdb databases?

950

What is database isolation in sql server? : sql server database administration

1085

What are the fixed server level roles? : sql server security

1103

Is null vs coalesce?

849

Can truncate be rolled back?

915

What is indexing explain it with an example?

990

What is the difference between value type and reference type?

904

Why main is user defined function?

997

What is data block and how to define data block size?

1013

Difference between connected and disconnected database in .net with sql server?

1074

Explain transaction server isolation?

1004

Explain primary key in sql server?

997