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 can I track the changes or identify the latest insert-update-delete from a table?

915

How to view existing indexes on an given table using sys.indexes?

1038

Explain an automatic checkpoint

916

Why do we partition data?

979

Differentiate between ms sql server reporting services vs crystal reports?

855

Why are you getting errors when creating a new odbc dsn?

1169

Tell me extended events in sql server 2008?

951

What is sql server used for?

991

What is SQL Azure Fabric?

108

Explain about analysis services?

982

what is a self join? : Sql server database administration

963

Define tool Manage Statistics in SQL Server 2000 query ?

1026

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

983

How do I find information about the install locations for the various instances running on a computer?

1033

How to automatically create a log when an exception is being received into SQL Server?

1213