Interested to Buy Any Domain ? << Click Here >> for more details...
How to get the count of distinct records. Please give me the
query?
- 8 Answers
- 12976 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
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
What are the restrictions while creating batches in sql server?
What is query processing?
How do you implement session management in SQL Server mode?
What is spid in sql server profiler?
how to define testing of network layers? : Sql server database administration
what are different types of raid configurations? : Sql server database administration
What is sql server locking?
How to write a query with an inner join in ms sql server?
What are commonly used mssql functions in php?
Explain syntax for viewing trigger?
How is table type constraint applied to a table?
what is package and it uses and how can u call a package
What is a transact-sql statement?
Can you explain various data region available in ssrs with their use?
