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 transaction properties?
How to turn on the mssql api module in php?
Difference between Logical Page and Physical Page in SSRS.
how to determine the service pack currently installed on sql server? : Sql server database administration
Explain the difference between control flow and data flow?
What encryption security is available in sql azure?
What is a collation?
How to create a testing table with test data in ms sql server?
what stored procedure would you use to view lock information? : Sql server administration
What is public role in sql server?
What is query optimizer in sql server?
What do I need to start working with sql studio? : sql server management studio
List the data types available in mssql?
How can you ensure that the database and sql server based application perform well?
What is identity?