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

Write a SQL queries on Self Join and Inner Join.

983

How you provide security to cube? : sql server analysis services, ssas

921

What are the different sql server versions?

930

What is the meaning of sql server?

934

What are functions in the sql server?

1126

How to write character string constants or literals in ms sql server?

957

How to Check if table exists in sql server?

1070

What is a collation?

1034

Is it possible to replicate data from sql server to oracle? : sql server replication

1033

When is update_statistics command used?

995

What happens if you are trying to access a schema not owned by you?

911

What is difference between aggregate and analytic function?

872

How do I open port 1433?

880

List out the differences between global and local temp tables in sql server?

999

What is de-normalization and what are some of the examples of it?

922