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
What is raiseerror? What is raiseerror?
What is rolap and its advantage? : sql server analysis services, ssas
What is sparse columns of sql server 2008?
What is the difference between index seek vs. Index scan?
What is the difference between rank and dense_rank?
What extended events?
How do you troubleshoot errors in a SQL Server Agent Job?
What are the different types of stored procedures?
Which language is supported by sql server?
What is page in sql server?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What is parameterized reports in ssrs ?
Do you know exporting and importing utility?
Differentiate sql server reporting services vs. Crystal reports?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?