How to get the count of distinct records. Please give me the
query?
Answer Posted / anusha
SELECT COUNT(*)FROM(SELECT DISTINCT columnname FROM
tblname)
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
Which language is supported by sql server?
What is the difference between local and global temporary tables?
How to delete exactly duplicate records from a table?
How can a database be repaired?
What is SQL Azure Fabric?
What is snapshot parameter in ssrs?
Define model database?
What is the difference between dropping a database and taking a database offline?
Can a table be created inside a trigger?
Can primary key be null?
What is update_statistics command?
What is an indexing technique?
What is clustered primary key?
What are different backups available in sql server?
What is parameterized reports in ssrs ?