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
Do you know what guidelines should be followed to help minimize deadlocks?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
What the difference between UNION and UNIONALL?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
How to download and install sql server 2005 books online?
Explain comment on transactions?
Can you explain what is sql server english query?
How to remove duplicate rows from table?
What is the difference between osql and query analyzer?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What area unit the various kinds of info compression introduced in sql server 2008?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
What is sharding?
Mention the uses of stored procedures.
How to find table changes in sql server?