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

Are null values the same as that of zero or a blank space?

1021

Explain atomicity?

1025

How many joins in sql server?

929

How to create a user to access a database in ms sql server using "create user" statements?

937

What is a document index?

1010

What do you understand by a view?

985

How can sql server instances be hidden? : sql server security

1118

What are the properties of the relational tables?

867

We need to perform what steps in the following order to work with a cursor?

1204

Explain the phases a transaction has to undergo?

1032

What is the difference between char, varchar and nvarchar?

1009

Explain the commands in sql server?

1019

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

986

How to delete duplicate rows?

971

How to execute stored procedure and set temp table in sql server?

1023