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

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

1010

What is the difference between sdf and mdf?

1300

What is the difference between DataRow.Delete() and DataRow.Remove()?

1226

What is row_number function?

1001

What do you understand by the data quality services in sql server?

948

How to enter date and time literals in ms sql server?

1014

what is datawarehouse?

1108

What is sql collation?

1201

Using the customer, and order table in northwind database, please write a query to produce xml?

1074

What are the different types of lock modes in sql server 2000?

947

What is bulkcopy in sql?

941

Name the different type of indexes in sql?

958

How to get a list of all tables with "sys.tables" view in ms sql server?

1032

What is the difference between varchar and nvarchar?

941

What is normalization 1nf 2nf 3nf?

1058