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

Where can you add custom error messages to sql server?

1096

What is difference between foreign key and unique key?

996

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

988

How to convert numeric values to integers in ms sql server?

1062

Can you pass expressions to function parameters?

1085

Explain what is dbcc?

995

How many types of functions are there in sql server?

917

What is data mart? : sql server analysis services, ssas

1036

What are the advantages of passing name-value pairs as parameters?

1151

Which are the two editions in which SQL Azure database available?

119

Explain transaction server explicit transaction?

913

List the different index configurations possible for a table?

923

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

939

How do I start sql server 2017?

919

Explain few examples of stored procedure over triggers?

1012