SELECT COUNT(*)FROM(SELECT DISTINCT columnname FROM tblname)

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

Question Posted / anusha

Answer Posted / anusha

SELECT COUNT(*)FROM(SELECT DISTINCT columnname FROM
tblname)

Is This Answer Correct ?

7 Yes

5 No

Please Help Members By Posting Answers For Below Questions

How network traffic be reduced by using the stored procedure?

1118

Can you pass expressions to function parameters?

1103

What is clustered vs nonclustered index?

946

What does ss stand for sexually?

1084

Explain what is lock escalation?

1064

Explain how dts is used to extract, transform and consolidate data?

998

What command would you use to add a column to a table in sql server?

1307

How to create a simple user defined function in ms sql server?

1019

what is denormalization and when would you go for it? : Sql server database administration

1183

What is Sqlpaging in SqlServer 2005 ?

1065

How to find related tables in sql server?

943

How to create an index on an existing table in ms sql server?

979

Explain triggers in sql?

950

What are the different acid properties?

1065

How do you make a trace?

1024