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
How extra digits are handled with numeric data type literals?
Which are the important points to note when multilanguage data is stored in a table?
Can you explain different types of joins?
How to update values in a table with update statements in ms sql server?
Why normalization is used?
how many type of indexing in database?
Explain view in sql server?
What does truncate do?
What is an entity-relationship diagram (erd)?
What is the bookmark lookup and rid lookup?
difference between Clustered index and non clustered index ?
What is sql server 2000 work load governor?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
What does this statement do @@rowcount?
What is molap and its advantage? : sql server analysis services, ssas