select count(distinct columnname) from table ,this is correct as i checked

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

Question Posted / name

Answer Posted / name

select count(distinct columnname) from table ,this is correct as i checked the query

Is This Answer Correct ?

13 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do you delete a data source?

953

What is database white box testing?

1077

Which data type columns are the best candidates for full-text indexing?

917

Define full outer join in sql server joins?

914

Explain triggers?

942

Explain features of analysis services?

923

What is 2nf in normalization?

945

can SSRS reports Cache results?

136

How to create a simple stored procedure in ms sql server?

974

Explain various data region available in ssrs with their use?

874

Can you tell me some of the common replication dmv's and their use? : sql server replication

870

What are system databases in ms sql server?

966

What are sql server functions?

937

What are pages and extents? : SQL Server Architecture

956

What is the difference between clustered index and primary key?

869