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 is the difference between for auto and for nested?
Do you know spatial data types - geometry and geography in sql server 2008?
Do you have any idea about the tcl commands?
What are the properties and different types of sub-queries?
How to insert multiple rows with a subquery?
Define Unique Key?
How raid can influence database performance?
Mention the 3 ways to get a count of the number of records in a table.
What are the joins in sql server? : sql server database administration
What happens if the update subquery returns multiple rows in ms sql server?
What is dirty read?
how can you attach more than 20 ldf files in sql server
How do I install only the client tools of sql server 2000?
What are cursors and when they are useful?
what is a deadlock? : Sql server database administration