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
How can I create a report based on a query? : sql server management studio
Explain about merge replications?
How to select some specific columns from a table in a query in ms sql server?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
How to list all user defined functions in the current database?
Tell me the difference between clustered and non-clustered index?
How to query multiple tables jointly?
How to write a query with a right outer join in ms sql server?
Which language is supported by sql server?
What are the different types of cursor?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
Describe and explain about SQL native client?
What is the native system stored procedure to execute a command against all databases?
What is a data source or ds? : sql server analysis services, ssas
How to drop an existing user defined function in ms sql server?