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 / anilreddy

Answer Posted / anilreddy

select count(distinct(columnname)) from tablename

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to convert a unicode strings to non-unicode strings?

1100

What does null mean?

984

What does indexation mean?

973

What is field in algebra?

1036

What are the steps to follow to configure SQL*Net?

1033

Explain sub-query?

947

Explain try...catch with sql server?

1021

What is sharding?

116

SQL Server Architecture ?

2452

List the different normalization forms?

974

What is use of attributehierarchyenabled? : sql server analysis services, ssas

1240

how many bits ip address consist of? : Sql server database administration

898

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

986

What is equi join with example?

1122

How many database files are there in sql server 2000?what are they?

1051