How to get the count of distinct records. Please give me the
query?
Answer Posted / anilreddy
select count(distinct(columnname)) from tablename
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
do you know how to configure db2 side of the application? : Sql server database administration
What is difference between getdate and sysdatetime in sql server 2008?
What is dbcc updateusage?
Explain contrast amongst grouped and non-bunched records?
Can we insert data if clustered index is disabled?
How to get nth highest salary from employee table.
How to make conditional sum in ssrs?
How to view existing indexes on an given table using sp_help?
What triggers long term care?
Difference between connected and disconnected database in .net with sql server?
What is stored procedures?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
How to write a query with a full outer join in ms sql server?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
how you can deploy an ssrs report?