How to get the count of distinct records. Please give me the
query?
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
Can you create a logon trigger in sql server 2005 express edition?
How can you check the version of sql server?
What do mean by xml datatype?
Why union all is faster than union?
What is user defined datatypes and when you should go for them?
Explain where clause?
Explain the difference between control flow and data flow?
What is constraints and its types?
What is the difference between web edition and business edition?
Describe the functionalities that views support.
How to handle error or exception in sql?
Explain what are partitioned views and distributed partitioned views?
What are the default system databases in sql server 2000?
What is DCL?
Explain log shipping?