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 do you mean by a Composite primary key?

1190

What is the template in sql?

1030

How to concatenate two strings in SQL Server.

1207

Write the SQL query to drop, truncate and delete table.

1028

Can we call stored procedure in view in sql server?

940

What is a rollup clause?

1018

Explain what are the restrictions that views have to follow? : SQL Server Architecture

1099

What is the chart in report?

165

What is a trigger what are the advantages of trigger?

1065

Find nth lowest salary or get nth lowest salary?

1082

What is function of CUBE ?

1077

What happens on checkpoint?

1070

Does a server store data?

954

Difference between report and query parameter.

1144

How you can change the database name in SQL SERVER?

1251