Interested to Buy Any Domain ? << Click Here >> for more details...
How to get the count of distinct records. Please give me the
query?
- 8 Answers
- 13195 Views
- Value Labs, I also Faced
- E-Mail Answers
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 are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
Is sql different from sql server?
what is blocking? : Sql server database administration
What is difference between cte and view?
Explain what is dbcc?
How can sql injection be stopped? : sql server security
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What is the difference between substr and charindex in the sql server?
How do you debug a procedure in sql server?
How do you use a subquery to find records that exist in one table and do not exist in another?
What are number line correlation administrators will use while working with a subquery?
What is the difference between Clustered and Non-Clustered Index?
What is a dbms wizard?
what are different types of raid configurations? : Sql server database administration
Is sql server is free?
