How to get max 100 values from sql server

Question Posted / babu

Answers were Sorted based on User's Feedback

How to get max 100 values from sql server..

Answer / rekha

select top 100 (field name)from table name order by (field
name) desc

Is This Answer Correct ?

14 Yes

6 No

How to get max 100 values from sql server..

Answer / zulfikar ali

SELECT TOP 100 FIELD_NAME
FROM TABLE_NAME
ORDER BY FIELD_NAME DESC

Is This Answer Correct ?

9 Yes

1 No

How to get max 100 values from sql server..

set rowcount 100
select * from tablename

Is This Answer Correct ?

4 Yes

3 No

How to get max 100 values from sql server..

SET ROWCOUNT 100

SELECT * FROM TABLENAME

Is This Answer Correct ?

2 Yes

3 No

How to get max 100 values from sql server..

Answer / karthi

select top 100 fieldname from tablename

Is This Answer Correct ?

1 Yes

5 No

How to get max 100 values from sql server..

Answer / ashis dey

select top 100 fieldname from tablename group by fieldname

Is This Answer Correct ?

0 Yes

4 No

How to get max 100 values from sql server..

Answer / vikas

select top 100 max(field name) from Table Name

Is This Answer Correct ?

12 Yes

17 No