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

Can a table be moved to different filegroup?

983

Where the sql logs gets stored?

994

Define self join in sql server joins?

962

what is the system function to get current user's user id? : Sql server database administration

1012

Who is the owner of a schema in ms sql server?

1082

What is key set driven?

964

What is the difference between having clause and where clause in sql server?

1111

What is “asynchronous” communication in sql server service broker?

1044

What are the steps you can take to avoid “deadlocks”?

982

What is the difference between executequery () and executeupdate ()?

1050

Which command is used for user defined error messages?

1068

How to compare the top two records using sql?

1354

How to create a store procedure with encryption?

1013

Can you import Microsoft Excel data to SSRS?

135

How to attach adventureworkslt physical files to the server?

1109