How to get max 100 values from sql server

Answer Posted / vikas

select top 100 max(field name) from Table Name

Is This Answer Correct ?    12 Yes 17 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a view and what are its advantages?

694


How are the exceptions handled in sql server programming?

613


How to create nested stored procedure?

548


Tell me what do you mean by an execution plan? Why is it used? How would you view it?

533


What are pessimistic lock and optimistic lock?

556






Why would you use sql agent?

740


Explain external key management in sql server 2008

512


What is an index. What are the types?

590


explain how to create a new schema in a database? : Sql server database administration

588


How to select true false based on column value in sql server?

514


What are views in ms sql server?

607


You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

633


What is use of except clause?

637


Do you know what is blocking?

549


What are “lock” hints?

599