select distinct (columnname) from tablename

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

Question Posted / soumya

Answer Posted / soumya

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the difference between clustered and a non-clustered index?

975

How would you use user_constraints table in DB?

939

Why do we use non clustered index?

1009

What is an active database?

961

What is the importance of a recovery model?

1001

What is relationship? What number of sorts of relationship are there?

1063

What are the components of sql server service broker?

945

We need to perform what steps in the following order to work with a cursor?

1168

what exactly sql injuction.how to overcome.....

2484

New concepts of sql server 2005 use in your project.

2303

What it means to be triggered?

911

Explain why variables called the most powerful component of ssis?

990

How to modify an existing stored procedure in ms sql server?

1009

Define Wed Edition in SQL Azure?

100

What are window functions in sql server?

937