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

What is the main difference between ‘between’ and ‘in’ condition operators?

1191


Why I am getting this error when renaming a database in ms sql server?

1052


What are the types of sql server?

1051


How to connect a database with sql express.?

1062


What are the disadvantages of primary key and foreign key in SQL?

1116


How can you hide the sql server instances?

1021


Why the trigger fires multiple times in single login?

1209


Do you know what is similarity and difference between truncate and delete in sql?

1007


What do mean by xml datatype?

1098


Can select statements be used on views in ms sql server?

1065


Explain the difference between HTTP and HTTPS in database?

1030


What is the maximum size per database for sql server express?

1049


Explain having clause?

965


What is read committed?

1084


What are the benefits of filtered indexes?

1040