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

Which language is supported by sql server?

1018

What is the difference between local and global temporary tables?

1140

How to delete exactly duplicate records from a table?

1063

How can a database be repaired?

993

What is SQL Azure Fabric?

110

What is snapshot parameter in ssrs?

150

Define model database?

985

What is the difference between dropping a database and taking a database offline?

1174

Can a table be created inside a trigger?

973

Can primary key be null?

936

What is update_statistics command?

1070

What is an indexing technique?

937

What is clustered primary key?

1029

What are different backups available in sql server?

1079

What is parameterized reports in ssrs ?

149