How to get the count of distinct records. Please give me the
query?
Answer Posted / name
select count(distinct columnname) from table ,this is correct as i checked the query
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
What is model database in sql server?
How to count groups returned with the group by clause in ms sql server?
What are the basic features of a trigger in ms sql server?
Where in ms sql server is ’100’ equal to ‘0’?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
How to retrieve error messages using mssql_get_last_message()?
List the different types of collation sensitivities in sql server?
Explain indexed views?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
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 dbcc? Give few examples.
What happens if null values are involved in boolean operations?
What is an active database?
Give an example of SQL injection attack ?
What is the difference between rank and dense_rank?