select count(distinct(columnname)) from tablename

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

Question Posted / anilreddy

Answer Posted / anilreddy

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the transaction properties?

963

What is user-defined function?

913

How do I get Report Builder to generate a parameter that can be set by users viewing the report?

139

wat wil hapn if we give the both read and deny read permission to user?

2061

What is function of master database?

114

How to add the custom code in Report?

117

What are the parts of a function?

870

Can we use where clause in union?

1001

How do I clean up sql server transaction log?

993

What is shrink log file?

843

What is ems sql management studio? : sql server management studio

1036

How to transfer an existing table from one schema to another schema in ms sql server?

925

What is database black box testing?

983

How optimize sql query with multiple joins in sql server?

826

How important do you consider cursors or while loops for a transactional database?

908