How to get the count of distinct records. Please give me the
query?
- 8 Answers
- 11400 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer Posted / anusha
SELECT COUNT(*)FROM(SELECT DISTINCT columnname FROM
tblname)
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
What is an active database?
What do you know about normalization and de- normalization?
What are the common performance issues in sql server?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What is scheduled job and how to create it?
How to remove duplicate rows from table except one?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
What is the process of normalization?
What is report rendering ?
What do you mean by recursive stored procedure?
How many types of local tables are there in sql server?
How can we use ConnectorJ JDBC Driver with MS SQL?
Can you pass expressions to function parameters?
Explain the difference between control flow and data flow?
How to call stored procedure using http soap?
