How to get the count of distinct records. Please give me the
query?
Answer Posted / gouri
SELECT count(*) FROM
(SELECT distinct ngcode FROM donation )d
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
Explain what is the purpose of sql profiler in sql server?
What are the built in functions in sql server?
How can I create a new template for import ? : sql server management studio
Explain an incremental backup?
Tell me what is fill factor?
What are binary string data types in ms sql server?
What is an execution plan? How would you view the execution plan?
Tell me what is de-normalization and what are some of the examples of it?
What are the restrictions while creating batches in sql server?
What is index, cluster index and nonclustered index?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
What is difference between joins and subqueries?
State a few properties of relational databases?
Explain trigger and its types?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?