Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answer Posted / gouri

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

Is This Answer Correct ?    4 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what is the purpose of sql profiler in sql server?

1132


What are the built in functions in sql server?

1029


How can I create a new template for import ? : sql server management studio

1113


Explain an incremental backup?

1052


Tell me what is fill factor?

1013


What are binary string data types in ms sql server?

1391


What is an execution plan? How would you view the execution plan?

1130


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

1098


What are the restrictions while creating batches in sql server?

1117


What is index, cluster index and nonclustered index?

1047


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

1046


What is difference between joins and subqueries?

1172


State a few properties of relational databases?

1181


Explain trigger and its types?

1116


Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

195