How to get the count of distinct records. Please give me the
query?

Answer Posted / name

select count(distinct columnname) from table ,this is correct as i checked the query

Is This Answer Correct ?    13 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is dbcc? : Sql server database administration

531


How adventureworkslt tables are related?

533


How to send a ssrs report from ssis?

125


What are distinctive joins find as a part of sql?

560


Explain the properties of the relational tables?

557






What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

609


How do I get to sql server configuration manager?

524


What is a join in sql? What are the types of joins?

526


How to rename databases in ms sql server?

631


What is a self join in sql server?

602


How do I view a procedure in sql server?

544


Can you create a logon trigger in sql server 2005 express edition?

579


Why do we need normalization?

497


What are the database roles? : sql server security

566


how we use window authentication connection with sql server.?

634