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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about analysis services?

1047

Define views.

1010

How will you add a dimension to cube? : sql server analysis services, ssas

1082

How do you make a trace?

1017

Explain about temporary stored procedure?

1016

What is the difference between ddl,dml and dcl commands?

1108

What is the filtered index?

1052

Explain nested trigger in sql?

1069

What are the different types of upgrades that can be performed in sql server?

1175

Explain encryption of entire databases without the need for application changes in sql server 2008?

1040

What is isnull() operator?

1037

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

1004

How to make a remote connection in a database?

973

What are different types of table joins?

1003

How can we solve concurrency problems?

1051