How to get the count of distinct records. Please give me the
query?
Answer Posted / kanika
this will also work
select count(distinct columnname) from table
Is This Answer Correct ? | 18 Yes | 1 No |
Post New Answer View All Answers
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
Differentiate between a local and a global temporary table?
What is a Join and explain its types?
How to create a login account in ms sql server to access the database engine using "create login" statements?
What do you mean by tablesample?
What are the different types of normalization?
what is unique and xaml nonclustered index
Difference between connected and disconnected database in .net with sql server?
how to determine the service pack currently installed on sql server? : Sql server database administration
Explain about extended stored procedure?
Explain about sql server login?
How to make remote connection in database?
How to use union to merge outputs from two queries together in ms sql server?
What are built in functions?
What command would you use to create an index?