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
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
How to connect sql server management studio express to sql server 2005 express?
How many databases Microsoft SQL server provides?
What is candidate key with example?
what is a self join? : Sql server database administration
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
What command is used to create a database in the sql server and how?
Do you know what are the restrictions that views have to follow?
Explain Geography datatype in SQL Server
Explain the rules for designing files and file groups in sql server?
What is measure group, measure? : sql server analysis services, ssas
What is the tcp/ip port on which sql server runs?
How do I uninstall sql server 2014?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
How to get a list of columns using the "sp_help" stored procedure in ms sql server?