How to get the count of distinct records. Please give me the
query?
Answer Posted / anusha
SELECT COUNT(*)FROM(SELECT DISTINCT columnname FROM
tblname)
Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
How to get the query of a table in sql server?
What is mean by candidate key?
Explain different backup plans?
What are policy management terms?
What do you understand by a stored procedure?
In which files does sql server actually store data?
what's the difference between delete table and truncate table commands? : Sql server database administration
How do you open a cluster administrator?
What is the difference between a primary key and a unique key? Are they the same?
how you can deploy an ssrs report?
Explain ms sql server reporting services vs crystal reports?
What is normalization? Describe its different types.
When to use null data driven subscription?
Explain different types of self contained sub query?
What is meant by datasource?