select distinct (columnname) from tablename

How to get the count of distinct records. Please give me the
query?

Question Posted / soumya

Answer Posted / soumya

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1018

What are the features of Embedded SQL

1127

Explain how to use linked server?

989

What is store procedure? How do they work?

1013

What are the restraints imposed on the table design by a merge replication?

1035

What is serializable?

1039

How can you set the threshold at which sql server will generate keysets asynchronously?

985

How can we solve concurrency problems?

1051

What is an entity-relationship diagram (erd)?

1210

how we use window authentication connection with sql server.?

1152

Why use “in” clause in sql server?

1071

what is a check constraint?

1109

What is user-defined inline table-valued function?

946

What is trigger and different types of Triggers?

1140

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

942