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 an etl file?

957

What triggers long term care?

1039

What is apply operator in sql?

1015

How to convert a table data in XML format in sql server?

2545

Explain filtered indexes?

1005

What happens if null values are involved in datetime operations?

976

How to concatenate two strings in SQL Server.

1152

What is cached report?

144

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

1012

What are the parts of a function?

943

How to copy the tables, schema and views from one sql server to another?

1050

What is a ddl statement?

919

What do you mean by collation recursive stored procedure?

1057

How to insert new line characters into strings?

994

What is the difference between grant and with grant while giving permissions to the user?

966