SELECT COUNT(*)FROM(SELECT DISTINCT columnname FROM tblname)

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

Question Posted / anusha

Answer Posted / anusha

SELECT COUNT(*)FROM(SELECT DISTINCT columnname FROM
tblname)

Is This Answer Correct ?

7 Yes

5 No

Please Help Members By Posting Answers For Below Questions

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

963

What happens when unicode strings concatenate with non-unicode strings?

1061

How to check parameter value in stored procedure sql server?

958

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

996

Explain sql server service broker?

954

What are information schema views?

957

What are truncate options available in sql server? : sql server database administration

1003

Does full backup break log chain?

946

Why do we use trigger?

948

what is an extended stored procedure? : Sql server database administration

1032

Do you know what is user defined datatypes and when you should go for them?

943

What is the user of Primary key?

958

What are the advantages dts has over bcp?

974

How you can find out if an index is useful to the optimizer?

919

What is meant by indexing?

990