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

What action plan is preferred if sql server is not responding?

1088

How to create a large table with random data for index testing in ms sql server?

1012

How ssrs maintain security?

1054

Explain foreign key in sql server?

1001

What are the new scripting capabilities of ssms? : sql server management studio

1041

How to stop log file growing too big?

998

What are the lambda triggers?

887

What are data resources?

892

Does windows server 2016 come with sql server?

918

How do you rebuild an identity column?

935

Do you know the cursor optimization tips?

965

What are the types of joins in sql?

1100

Can binary strings be used in arithmetical operations?

911

How to concatenate two character strings together?

1100

Ways to improve the performance of a SQL Azure Database?

125