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
Can we perform backup restore operation on tempdb?
What are statistics?
What is change data capture (cdc) feature?
How can delete duplicate records in cte in sql server?
How exceptions can be handled in sql server programming?
What is extended stored procedures?
Explain log shipping and mention its advantages.
How many partitions a clustered index has by default in sql server 2012?
How to achieve Paging of records in SQL SERVER?
What are diverse clauses that form a part of sql?
Mention the different types of triggers?
What is xml datatype?
How do I trace a query in sql server?
What is the usage of sign function?
Explain indexed views and partitioned view with their syntax.