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


Please Help Members By Posting Answers For Below Questions

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?

874


How to connect sql server management studio express to sql server 2005 express?

586


How many databases Microsoft SQL server provides?

615


What is candidate key with example?

518


what is a self join? : Sql server database administration

526






Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

542


What command is used to create a database in the sql server and how?

609


Do you know what are the restrictions that views have to follow?

630


Explain Geography datatype in SQL Server

633


Explain the rules for designing files and file groups in sql server?

554


What is measure group, measure? : sql server analysis services, ssas

556


What is the tcp/ip port on which sql server runs?

570


How do I uninstall sql server 2014?

526


Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

706


How to get a list of columns using the "sp_help" stored procedure in ms sql server?

584