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 a table be moved to different filegroup?
Where the sql logs gets stored?
Define self join in sql server joins?
what is the system function to get current user's user id? : Sql server database administration
Who is the owner of a schema in ms sql server?
What is key set driven?
What is the difference between having clause and where clause in sql server?
What is “asynchronous” communication in sql server service broker?
What are the steps you can take to avoid “deadlocks”?
What is the difference between executequery () and executeupdate ()?
Which command is used for user defined error messages?
How to compare the top two records using sql?
How to create a store procedure with encryption?
Can you import Microsoft Excel data to SSRS?
How to attach adventureworkslt physical files to the server?