SELECT count(*) FROM (SELECT distinct ngcode FROM donation )d

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

Question Posted / gouri

Answer Posted / gouri

SELECT count(*) FROM
(SELECT distinct ngcode FROM donation )d

Is This Answer Correct ?

4 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How to copy the tables, schema and views from one sql server to another?

1047

How do I perform an unattended install of sql server 2000?

1086

Explain aggregate functions?

1081

what stored procedure would you use to view lock information? : Sql server administration

973

Tell me what is sql profiler?

1029

What is store procedure? How do they work? When do you use?

942

Do you know what is rank function?

1073

What are “unrepeatable reads”?

1234

What are the requirements for sql server 2016?

882

What are the types of joins in sql?

1126

What is the difference between stored procedure and functions?

1134

What is meant by Active-Passive and Active-Active clustering setup?

1176

Are null values the same as that of zero or a blank space?

1040

What is the difference between left and right outer join?

1061

What is inner join in sql server joins?

1035