How to get the count of distinct records. Please give me the
query?
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
What are the new features in sql server 2016?
What is the function of inner join?
How many columns can exist together per table?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
What is 1nf normalization form?
How to list all user names in a database?
What are the character string functions supported by sql server 2005?
How does stuff differ from the replace function?
do views contain data ?
How many types of attribute relationships are there? : sql server analysis services, ssas
Differentiate between a local and a global temporary table?
What is the difference between set and select?
application server is slow what may be the problem
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?