How to get the count of distinct records. Please give me the
query?
- 8 Answers
- 11403 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer Posted / kanika
this will also work
select count(distinct columnname) from table
| Is This Answer Correct ? | 18 Yes | 1 No |
Post New Answer View All Answers
How can I track the changes or identify the latest insert-update-delete from a table?
What are data driven subscriptions?
Define constraints and give an example of their use?
What is an indexing strategy?
Name few of the dcl commands in sql?
What are null values in ms sql server?
Can we deploy SSRS reports on our personal website?
How is SQL Azure different than SQL server?
What is the return type of executeupdate ()?
Explain the benefits of user-defined functions?
What area unit the various kinds of info compression introduced in sql server 2008?
What is a document index?
How to include text values in sql statements?
What is an entity-relationship diagram (erd)?
What is change tracking in sql server?
