How to get the count of distinct records. Please give me the
query?
- 8 Answers
- 11401 Views
- Value Labs, I also Faced
- E-Mail Answers
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
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
What are clustered and non-clustered index?
What is the use of @@spid?
Can sql servers linked to other servers like oracle?
Explain different backup plans?
How to create a simple stored procedure in ms sql server?
How to change server name in sql server?
Is resultset an interface?
How to Insert multiple rows with a single insert statement?
What are the types of processing and explain each? : sql server analysis services, ssas
How can you fetch alternate records from a table?
How to remove duplicate rows from table?
What is a mixed extent?
How to enter binary string literals in ms sql server?
How can you hide the sql server instances?
