How to get the count of distinct records. Please give me the
query?
- 8 Answers
- 11397 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer Posted / pradyumna
select distinct colname,count(colname) from tbl group by
colname
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are indexers?
How do I find the sql server version?
Do you have any idea about the tcl commands?
What is SQL Azure Firewall?
What is the difference between locking and multi-versioning?
Explain subquery and state its properties?
What are the differences between ms sql server & oracle?
What is the difference between left and right outer join?
What is the default schema of your login session in ms sql server?
Do you know what is a linked server in sql server?
Explain the disadvantages/limitation of the cursor?
What are the advantages of paper records?
How are the unique and primary key constraints different?
When multiple after triggers are attached to sql table, how to control the order of execution?
What is report snapshot?
