select top 100 fieldname from tablename group by fieldname

How to get max 100 values from sql server

Question Posted / ashis dey

Answer Posted / ashis dey

Is This Answer Correct ?

0 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is the contrast between sql and pl/sql?

1136

What are constraints?

997

How to how to convert numeric expression data types using the convert() function??

1044

Explain unique key in sql server?

1006

Explain what is analysis service repository?

979

How to specify the collation for a character data type in ms sql server?

1019

How to create new databases with "create database" statements?

1017

Does view occupy space?

934

How to use clusters?

934

What is your recommendation for a query running very slow? : sql server database administration

1036

What is blocking and how would you troubleshoot it? : sql server database administration

1039

What is sub query and its properties?

970

Should you normalize audio?

933

What is PROJECTION Operation?

1011

application server is slow what may be the problem

2212