select distinct colname,count(colname) from tbl group by colname

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

Question Posted / pradyumna

Answer Posted / pradyumna

select distinct colname,count(colname) from tbl group by
colname

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Do you know the policy based administration feature of sql server 2008?

959

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1965

How can you tell if a database object is invalid?

1074

How many primary keys are possible in a table?

926

Does sql server 2016 have ssms?

960

what is bit datatype? : Sql server database administration

917

What are the differences between DDL, DML and DCL in SQL?

1229

How do I find my localdb version?

986

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1148

What are the general features of sql server management studio? : sql server management studio

1077

What are scalar functions in sql?

1145

How can you manage sql azure security?

101

New concepts of sql server 2005 use in your project.

2360

How will you add a dimension to cube? : sql server analysis services, ssas

1086

What is the maximum length of an alert name?

1001