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
What is meant by indexing files?
Define a cross join?
How to set the current database in ms sql server?
What is difference between drop truncate and delete?
Explain about Normalization?
Explain error and transaction handling in sql server?
What is blocking?
How to replace the Query Result 'Null Value' with a text ?
What is buffer cash and log cache in sql server?
How to run queries with sql server management studio express?
what method you can use to reduce the overhead of Reporting Services data sources?
What are the events recorded in a transaction log?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
do views contain data ?