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

What is sql azure database?

188

Do you know how to make remote connection in database?

554

What is the difference between migration and upgradation in sql server?

609

How do you create a data source?

480

Can a database be shrunk with users active?

607

how many type of indexing in database?

584

How to enter binary string literals in ms sql server?

584

How to list all stored procedures in the current database using ms sql server?

639

In how many ways you can invoke ssrs reports?

103

How many partitions a clustered index has by default in sql server 2012?

664

How can i Relate Tables in SSIS

577

can you instantiate a com object by using t-sql? : Sql server database administration

523

What is a group function explain with an example?

523

What are data driven subscriptions?

How to modify existing triggers using "alter trigger"?

531