this will also work select count(distinct columnname) from table

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

Question Posted / kanika

Answer Posted / kanika

this will also work

select count(distinct columnname) from table

Is This Answer Correct ?

18 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is encryption key?

139

Tell me what is difference between view and materialized view?

985

Are resultset updatable?

1010

How can sql injection be stopped? : sql server security

1106

what is the difference between openrowset and openquery?

1164

role of sql sever 2005 in database rather than any other database

1993

Do comments need to go in a special place in sql server 2005?

919

Tell me in brief how sql server enhances scalability of the database system?

1048

Explain multiserver query

1115

Explain indexes disadvantages?

1147

What is the difference between ddl,dml and dcl commands?

1162

explain different types of cursors? : Sql server database administration

1150

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

1017

What is report server project?

155

What happens if null values are involved in string operations?

1032